Viewing 15 posts - 14,026 through 14,040 (of 49,552 total)
polkadot (3/5/2013)
March 5, 2013 at 2:47 pm
Google for 'Gaps and Islands' Itzik Ben-Gan
He's written a huge about on several ways to get this kind of result.
March 5, 2013 at 1:49 pm
polkadot (3/5/2013)
So user names are not logged in any system tables, right?
User names are in several of the system tables and DMVs.
And profiler would have to be...
March 5, 2013 at 1:48 pm
qur7 (3/5/2013)
March 5, 2013 at 12:56 pm
polkadot (3/5/2013)
March 5, 2013 at 12:46 pm
Tablock -> take locks at the table level. If the statement would normally take shared locks, that will be a shared table lock. If the statement would normally take exclusive...
March 5, 2013 at 10:59 am
This is a Microsoft SQL Server forum, if you have Sybase questions I'm sure that you'll get better answers on a Sybase forum.
March 5, 2013 at 10:16 am
The allow_row_locks column in sys.indexes for the clustered index.
March 5, 2013 at 9:36 am
If the database is online, the password on the certificate backups is irrelevant, you can take new backups with any password you want (see Books Online for details).
March 5, 2013 at 8:58 am
Arjun Sivadasan (3/5/2013)
Thanks Gail. For an SP, there can be multiple entries in the dm_exec_query_plan DMV even without SP recompilation is what this implies, right?
No. A procedure has a single...
March 5, 2013 at 6:00 am
Backups are pretty much an IO bound operation. Check the latency and throughput on the drives.
March 5, 2013 at 5:19 am
Why not just take a backup, copy the backup across and restore on the other server?
March 5, 2013 at 4:36 am
A single piece of dynamic SQL will not cause the entire procedure to recompile. At worse, the dynamic section will compile each time, but that depends on a number of...
March 5, 2013 at 4:22 am
Bit of a large question. Entire books have been written on the subject. Literally.
http://www.amazon.com/Server-2012-Query-Performance-Tuning/dp/1430242035/
March 5, 2013 at 4:20 am
Viewing 15 posts - 14,026 through 14,040 (of 49,552 total)