Is there a way to to delete the backlog in SharePlex? I have the queue shut down but there is still a backlog. I googled and read SharePlex admin guide, and all I could find is that the delete queue command will fail if there is a backlog.
i have some code here but first i want to explane my question.
i want to create a view but thats not possible in a view because my SELECT statement hase some variables in it i have seen some answers with function but i dont know how the parameters works.
here is my code
CODE:
DECLARE @totalR...
I am trying to import a xml (actually a docx file) to a sql server 2008 database. I am almost a novice in XML programming. I googled a lot but almost all the examples there are with simple xml file. Here the xml file is little complex(please see below). Can you please give me some idea how I shou...
@ChrisTravers I unfortunately use it only for my pleasure now (rarely). Company is using Powershell and pushing it everywhere. And when I watch at all the $$$$ there I won't think of programming :-).
@ChrisTravers Only SQL Server. Worked (a bit) with Oracle and MySQL in the past, but nothing too important. Just simple development tasks.
@ChrisTravers but fortunately MS SQL is a huge platform. We have SQL Server (the OLTP engine), SSAS (the cube engine), SSRS (reporting engine), SSIS (ETL engine).
Does a system primary key or unique identifier for each row in a table exist? Like @@ROWID, @@IDENTIFER, or some other identifier that uniquely identifies each row regardless of how it was created. Using SQL Server 2000 through SQL Server 2012.
@gbn and there's more to it: the 2012 with all additions, PDW (for immortals), StreamInsight (looks interesting)
@ChrisTravers CLR is pretty useful, but haven't seen many devs liking it too much. They still prefer to write .NET for the app code and SQL or some ORM code for the db stuff.
How do CTE memory space work? When you have complex SQL statements executing with the CTE and you get unusually large result set, can it increase the logical reads of the query?
I have a CTE that is executing 32 trillion reads, and other times it runs with 200K
I try to store my 100G table into mysql cluster, and as I know that mysql cluster is an inmemory database... and I don't have that much memory(aleast 100G) to store my table, but I found that in mysql cluster version 6.x or 7.x or higher, it support disk data storage
so, I follow this site : http...
@Marian Hahaha, that CTE question is from one of my clients. I made him post it in public rather than me answering it via email. Told him I'd tweet it if it didn't have good answers by Monday.
@Marian if it's a recursive CTE it's easily possible
You can have 100 iterations of a CTE
if its self-referencing and reads itself each time, and the original query does say 2 scans, in 100 iterations you have 1,267,650,600,228,229,401,496,703,205,376 scans
For a weak network I wouldn't personally use Mirroring. But if you really want mirroring for the specific case when there might be a slow connection an option would be to use the Asynchronous mode (or High Performance mode). This would imply some data loss would be possible, but
Details on MSDN:...
can you reconfigure mirroring without breaking it?
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
UPDATE
Tried login in Single User mode
But error shows as
Login failed for user 'SERVER\Administ...
@jcolebrand @JNK I found a formatting issue with the DBA mod election site that doesn't exist on the SO election site. Should I post it on DBA Meta or main Meta?
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
I tried logging in using single user mode as Remus described but I get the following error:
Log...
I'm trying to reinstall vCenter SSO and it is prompting me for the "sa" password. I set it up previously, but cannot remember what I used. I uninstalled SSO (as well as the vCenter Server, and Inventory Service), and I'm running through setup again. I can't get past setting up the database wit...
The title on the new question is wrong, too. You can disable SQL auth on SQL Server, but you can't disable Windows auth. So it's the sa account he needs to recover access to, not re-enable Windows auth
I think it is because of the comment that @JackDouglas edited into the mod pages but the layout is now broken on mobile devices, at least on an iphone it is
@bluefeet funny, this morning I was on my iPhone and with the mobile interface I couldn't figure out how to get to the election page (I'm far too lazy to memorize a URL). So I switched to the full site. Is that the layout that is broken?
At this point we have no plans to extend Markdown syntax to support tables. The extension itself isn't the hard part. The display of tables in posts would be fairly hard to get right.
There are a few extensions already (like what PHP Markdown does), but the syntax isn't very intuitive, and it's ...
Thank you for adding the screen shot because - while in many aspects I consider myself quite technical - I have absolutely no idea how to use your script. The result is prettier, but I'm not sure it's worth the additional work required over formatting in other existing methods (there is some ascii table prettifier that people use, but I just use SSMS and region editing to inject the right spacing efficiently).
@AaronBertrand the idea is mainly that we could cut'n'paste from SQLFiddle's markdown output and get pretty tables for free, rather than hand formatting
@JackDouglas yeah I get that, I'm just saying for me 99% of the time if I'm pasting tabular output it's from Management Studio grid results, not SQLfiddle.
So using SQLfiddle will, in most cases, add additional steps to my process.
I have about 350000 files in my Amazon S3.
I need to transfer them to a MySql database running in my server..
Which is the best way to do this?
I saw this post which uses Pipeline, but Pipeline is for intermittent updates as far as I can understand. I am not sure how transferring large volumes...
That response is getting pretty common no matter who the submitter is. In a lot of cases it seems to simply be a "will this sell more licenses?" question. If no, closed.
@AaronBertrand is this because of the current focus on R&D/new features? is that a way to positively view this? or is it really just as Andreessen said ... we're in the dark ages of tech
@djechlin but to be relevant here that would require a comment and a down-vote. They're not always hand-in-hand - many down-voters don't comment, either because of retribution paranoia or because someone else already made an accurate comment about the problem. I would like to have some easy way to review modifications made to posts I've down-voted regardless of whether I've commented and regardless of whether the OP has bothered to click some forthcoming "I've resolved this comment" button. — Aaron Bertrand7 mins ago
@JackDouglas "In order for this site to work properly, and in order to evaluate and improve the site we need to store small files (called cookies) on your computer..."
I strongly recommend you treat down-votes with a grain of salt. People down-vote for all kinds of reasons and not all of them have to do with the quality of your post.
Losing 2 rep is really nothing. What does your rep on this site really mean? On the other hand, deleting a question can much mor...
I know that the Moderator Election pages do not have a mobile version by design but when viewing the DBA.SE election page the comments overflow beyond the column for each nominee which does not happen on the Stack Overflow election page.
DBA.SE Mod Election page on iPhone:
Stack Overflow Mod ...
AOO1 , AOO2 , BOO3 , A005 , D006 , AGFHG
This data what I have in one of my column, now what I want to do is:
I want to replace starting A letter with the letter E.
What is the update query for this
If anyone else has contemplated standing in the election, please don't hold back. It'd be healthy to have one or two more candidates so the eventual winner can feel like they have really been elected: you'd be doing everyone a favour.
Build an SSIS package. Just create a new Data Flow task. Use two OLEDB sources make one of them execute the stored procedure and the other one select from the table you are looking to MERGE with. Make sure they are both ordered by the same thing. Go into advanced settings for each OLEDB source an...
@AaronBertrand That should work for him. Wish I could add pictures but there is to much to do.
For merging data from what seems to be two tables in the same database, I don't think SSIS really accomplishes using "MERGE" syntax anyway, even if the thing you choose in SSIS is called MERGE
@AaronBertrand It's safe to say the OP is over complicating this and could just follow your suggestion just wanted to give him another option.
To harsh?
I know you've given me a solution that provides 99% of what I need now can you hurry up and give me the other 1%. Come on man show a little effort. — Zane33 secs ago
Is there a way to to delete the backlog in SharePlex? I have the queue shut down but there is still a backlog. I googled and read SharePlex admin guide, and all I could find is that the delete queue command will fail if there is a backlog.
i have some code here but first i want to explane my question.
i want to create a view but thats not possible in a view because my SELECT statement hase some variables in it i have seen some answers with function but i dont know how the parameters works.
here is my code
CODE:
DECLARE @totalR...
Does a system primary key or unique identifier for each row in a table exist? Like @@ROWID, @@IDENTIFER, or some other identifier that uniquely identifies each row regardless of how it was created. Using SQL Server 2000 through SQL Server 2012.
How do CTE memory space work? When you have complex SQL statements executing with the CTE and you get unusually large result set, can it increase the logical reads of the query?
I have a CTE that is executing 32 trillion reads, and other times it runs with 200K
I'm trying to reinstall vCenter SSO and it is prompting me for the "sa" password. I set it up previously, but cannot remember what I used. I uninstalled SSO (as well as the vCenter Server, and Inventory Service), and I'm running through setup again. I can't get past setting up the database wit...
I have about 350000 files in my Amazon S3.
I need to transfer them to a MySql database running in my server..
Which is the best way to do this?
I saw this post which uses Pipeline, but Pipeline is for intermittent updates as far as I can understand. I am not sure how transferring large volumes...
I know that the Moderator Election pages do not have a mobile version by design but when viewing the DBA.SE election page the comments overflow beyond the column for each nominee which does not happen on the Stack Overflow election page.
DBA.SE Mod Election page on iPhone:
Stack Overflow Mod ...
If you do not need any actual aggregations then you should be able to use DISTINCT :
SELECT DISTINCT EmpID, name, code
FROM employees
AOO1 , AOO2 , BOO3 , A005 , D006 , AGFHG
This data what I have in one of my column, now what I want to do is:
I want to replace starting A letter with the letter E.
What is the update query for this
