Viewing 15 posts - 16 through 30 (of 53 total)
Even better is to capture the wait_stats at two (or more) different times and query the delta. I have this script that gives me a quick 10 second snapshot of...
June 12, 2018 at 9:01 am
Rather than run the job every 2 minutes why not use SQL Server Agent to run the job when it detects a blocked session?
1) Set server "blocked process...
April 5, 2018 at 11:27 am
I've seen the acronym RBAR (row by agonizing row) used to describe this. If the client that's doing the row-based processing is on a separate machine, you'll need to add...
February 23, 2018 at 10:37 am
I'd like the same and for exactly the same reason. Unless MS provides this necessary functionality, the only idea I can think of would be to fire a job and...
October 26, 2017 at 9:31 am
That's simply not true. An instance will not hang because you filled the tempdb database. Queries will fail and the instance will throw errors like 1105, but it most certainly...
January 10, 2017 at 11:07 am
I realize this is a very old thread but here is my .02 having managed numerous SharePoint databases. After all someone may still end up at this thread looking for...
January 10, 2017 at 7:41 am
Same problem here. Same exact faulting module, exception code, and offset. I checked the technet article referenced and it does not apply (we are not using linked servers to Oracle)....
October 11, 2016 at 7:22 am
Frankly t-sql scripting is better than either PL/SQL or whatever MySQL currently offers. I've administered all 3. The flow control in sqlplus or mysql is pretty lacking. All of my...
April 1, 2016 at 7:18 am
Better to just store the passwords in a password vault. 😉 By the time you crack it, the server will be decommissioned!
I tried to crack a password that I know...
April 24, 2015 at 7:35 am
According to the --help output, -m 131 is for sql 2000. For sql 2008 use -m 132
April 24, 2015 at 6:13 am
That's not completely true and exactly what this article seeks to discuss. If you introduce a failover clustered instance of sql server into the AO group there is still shared...
February 10, 2014 at 12:27 pm
Good article.
IMO Microsoft has "one upped" Oracle with Always On over Oracle's RAC solution.
I am a multi-platform DBA. I administer both SQL Server with Always On, and Oracle RAC. SQL...
February 10, 2014 at 11:22 am
I know this is an old topic but I thought I'd update it anyway. I did find a way to backup standby databases using the "backup" command. It works...
January 21, 2014 at 9:01 am
tskelley (1/17/2014)
I did add
AND INDEX_ID = 0
to the WHERE clause to keep my name list unique and not show indexes....
January 17, 2014 at 8:45 am
Viewing 15 posts - 16 through 30 (of 53 total)