Reputation
28,845
Next tag badge:
96/100 score
25/20 answers
Badges
5 56 98
Newest
 Revival
Impact
~1.6m people reached

May
29
comment Powershell function to drop table(s) from SQL Server database
I know I recommended using this site to post your code, but for the rest of the viewers can you explain what your problem is and what is happening?
May
15
comment How to capture Query Status(Sleeping, Background, Running) in SQL Server Profile trace
What exactly are you trying to do?
Apr
8
comment Alwayson cannot fail over using tsql
I think you are looking at this the wrong way. You shouldn't care which node owns the core cluster resource group (and resources). You care which node owns the SQL Server AG cluster resource group, which will most definitely be the same server/node that hosts the primary replica of the availability group.
Apr
8
comment Alwayson cannot fail over using tsql
What error(s) do you get when you attempt to failover via T-SQL?
Mar
14
comment reorganize and UPDATE
No data needs to be updated here. select * from TICKETS order by TicketID;
Mar
14
comment Take action from extended event?
What you can do is hook into XEvents event stream and take action that way. Very powerful, the sky is the limit. Information on how to accomplish this can be found here: tstringer.azurewebsites.net/?p=821
Mar
4
comment Backup terminating abnormally
@AaronBertrand The command is in the input buffer, and the error is an access violation. RFSonders, my recommendation would be to open up a case with SQL support.
Mar
4
comment SQL Server: get meta-Info about LDF-File
See my answer below for more information, but what are you trying to accomplish with this data? What's the bigger picture?
Mar
3
comment How can I speed SQLPS connection when I don't have WMI permissions at the server
Can you add to your question the PowerShell that you're running, as well as the verbose warning messages?
Feb
27
comment Long running DBCC CHECKDB
Have you looked to see if the DBCC CHECKDB request is being blocked during this time?
Feb
27
comment Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
Can the downvoters please explain why the downvotes?? This looks like a fine question to me.
Feb
27
comment Return list of columns in user-provided subquery
@MisterMagoo No problem at all!
Feb
26
comment Return list of columns in user-provided subquery
@MisterMagoo There you go :-) Only the necessary code to eliminate any confusion.
Feb
26
comment Return list of columns in user-provided subquery
@MisterMagoo This was just to illustrate how to do this. There are 100s of omitted things that should be in development, but to keep code brief I kept them out.
Feb
26
comment Return list of columns in user-provided subquery
Are you using SQL Server? If so, what version?
Feb
25
comment SQL Cluster, AlwaysOn AG, or Something Else?
A SAN does not need to be used with a Windows Cluster and an availability group. You will need shared storage if you go with a failover cluster instance (SQL).
Feb
23
comment Transaction log backup file larger than expected?
1 single data modification command can create way more than 3 MB of transaction log consumption :-) It all depends on how much churn there is. It's not a direct relationship between DML command count and log generation.
Feb
23
comment Transaction log backup file larger than expected?
What is your definition of "nominal" activity? How frequently are your transaction log backups? The size would be due to that amount of logged operations that need to be backed up.
Feb
12
comment Full to Simple recovery mode during massive data update?
@AaronBertrand Right, of course :-) I didn't want to assume what the OP was doing during that entire duration.
Feb
12
comment Full to Simple recovery mode during massive data update?
The only thing you're gaining out of putting the database in simple recovery mode is minimal logging. You can gain this by switching the database to bulk logged, and therefore not break your log chain.