Viewing 15 posts - 16 through 30 (of 152 total)
September 19, 2012 at 1:15 pm
Check if you have appropriate indexes.
Jason
http://dbace.us
😛
September 18, 2012 at 10:57 am
DBA, it is called archiving or set to read-only.
Jason
http://dbace.us
😛
September 7, 2012 at 12:56 pm
Most server comes with 8 SAS drive connectors as default. You can have 4 RAID1 or 2 RAID10 without extra cost. You run out of disk groups soon because you...
Jason
http://dbace.us
😛
August 14, 2012 at 6:18 pm
I think Kevin is right on target. I have an instance like that. The fix is in CU4 after SP3.
Jason
http://dbace.us
😛
July 10, 2012 at 9:35 am
Grant Fritchey's ebook from redgate ---- you must read.
Jason
http://dbace.us
😛
June 25, 2012 at 2:56 pm
I still do not comprehend a lot of the disk mirror/replication
Using software like doubletake, you can replicate (copy) disk array at data-block level to another environment and keep them in...
Jason
http://dbace.us
😛
June 25, 2012 at 8:22 am
I had all databases in "recovery pending" not because of disks nor memory. It was from SQL Server upgrade running into an error. The error was caused by 3rd party...
Jason
http://dbace.us
😛
June 21, 2012 at 11:05 am
How does this fall back to developers?
Msg 6512, Level 16, State 27, Line 1
Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80004005. You need to restart SQL...
Jason
http://dbace.us
😛
June 18, 2012 at 2:00 pm
I would change f.size to f.maxsize. case when 0, -1 use f.size.
Also the 2005 table is sys.database_files. sys.sysfiles is only provided for backward compatibility.
Jason
http://dbace.us
😛
June 5, 2012 at 12:04 pm
The scheme and the idea are very good. However, I will suggest improvement as:
1) make threshold parameter of the SP so you can change it on the agent job without...
Jason
http://dbace.us
😛
May 30, 2012 at 10:47 am
The reason large select is blocking is due to lock-escalation. In SQLServer2008, you can disable lock-escalation by command set lock-escalation disable. How big is your select? How many tables? Have...
Jason
http://dbace.us
😛
May 26, 2012 at 6:57 am
For example, a specific code case, procedure sys.sp_MSacquireSlotLock,
this is a procedure used in merge replication to limit the number of concurrent merge process. However, when the exclusive lock cannot be...
Jason
http://dbace.us
😛
May 24, 2012 at 10:49 am
You can find the documentation on SQLServer2008R2 BOL.
This is one of the stupid design.
Imagine old days, you go to library asking for a book for a page you need. It...
Jason
http://dbace.us
😛
May 23, 2012 at 8:46 am
Just a side note, SELECT INTO only works for new table, it works for this scenario asked.
For on-going archive, you can write a controlled transaction if you are not...
Jason
http://dbace.us
😛
May 22, 2012 at 8:27 am
Viewing 15 posts - 16 through 30 (of 152 total)