Viewing 15 posts - 1 through 15 (of 15 total)
GilaMonster - Wednesday, March 15, 2017 3:22 AMPlease note: 3 year old thread.
Yes, apologies about that. As the thread came up in...
March 17, 2017 at 1:16 am
For the record, using your SQL 2014 license key to install the equivalent version of SQL 2012 doesn't work. At least not in the situation I'm looking at, where someone...
March 15, 2017 at 12:34 am
Yeah shrinks suck, we have the fun task of pulling all of our Image Blob data out to disk for a few clients coming up. For the most recent client...
June 9, 2014 at 2:44 am
Good article, just wanted to add that we use the Ola Hallagren script suite for maintaining statistics at a lot of our larger client sites. Basically, updating stats was taking...
June 9, 2014 at 2:20 am
Thanks to you both, great stuff! Those two approaches are the ways I assumed it could be solved, and they both work. By either wrapping in further statements and by...
December 19, 2013 at 10:56 pm
Actually after checking out vSphere the SQL server is only sharing the host with two of our test servers, there really shouldn't be much contention at all.
August 19, 2013 at 8:18 pm
Thanks for the reponses!
I have a bit of reading to do on the VMWare side of things, the config is starting to worry me. Does bad config/contention on the host...
August 19, 2013 at 7:36 pm
jorge.rodriguez (2/1/2011)
-- 1. Ping and telnet your principal and mirror servers: if you cannot ping or telnet, this can be your problem (add your ips on your host files and...
July 29, 2013 at 7:32 pm
Interesting, this is probably context specific, but how does SQL deal with the alphanumeric "numbers" in that table? Say we pad all the values and choose an @val...
July 17, 2013 at 9:24 pm
Voide (7/15/2013)
Seeing as I work in medical these tables look a lot like NextGen tables 😉
Dunno much about NextGen but "OBR" and "OBX" are sure indicators that HL7 is involved...
July 17, 2013 at 8:59 pm
rray 44280 (6/10/2013)
I'm happy to do it via the backup and restore method, and that seems to be the approach I see discusse most often. Thanks!
Well, detaching and attaching is...
June 12, 2013 at 12:04 am
Advisable to take a full backup of the source beforehand anyway 😀
June 10, 2013 at 2:49 am
Directory lookup for the file "C:\CodePlex Database\AdventureWorks2012_log.ldf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft SQL Server, Error: 5133)
SQL server can't find the log...
May 27, 2013 at 8:53 pm
Before:
IndexName IndexID IndexType PartitionNo NumRows InType NumPages TotKBs UsedKBs DataKBs
Pk__Key 1 CLUSTERED 1 1770892 LOB_DATA 84581293 676650344 676590280 0
Pk__Key 1 CLUSTERED 1 1770892 IN_ROW_DATA 19946 159568 159448 157520
Pk__Key 1 CLUSTERED 1 1770892 ROW_OVERFLOW_DATA 0 0 0 0
DK_ 2 NONCLUSTERED 1 1770892 IN_ROW_DATA 5834 46672 46552 44912
And after:
Pk__Key 1 CLUSTERED 1 1770892 LOB_DATA 84581293 676650344 676590280 0
Pk__Key 1 CLUSTERED 1 1770892 IN_ROW_DATA 19946 159568 159448 157520
Pk__Key 1 CLUSTERED 1 1770892 ROW_OVERFLOW_DATA 0 0 0 0
DK_ 2 NONCLUSTERED 1 1770892 IN_ROW_DATA 5834 46672 46552 44912
And after the index rebuild:
Pk__Key 1 CLUSTERED 1 1770892 IN_ROW_DATA 10915 87320 87272 86392
DK_ 2 NONCLUSTERED 1 1770892 IN_ROW_DATA 2546 20368 20312 20240
April 16, 2013 at 7:40 pm
Perry Whittle (4/16/2013)
Once you drop the column have you tried querying the system catalogs to see what allocated, used and reserved space sql server thinks the table\index object has?
Not directly...
April 16, 2013 at 1:37 am
Viewing 15 posts - 1 through 15 (of 15 total)