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:
IndexNameIndexIDIndexTypePartitionNoNumRowsInTypeNumPagesTotKBsUsedKBsDataKBs
Pk__Key1CLUSTERED11770892LOB_DATA845812936766503446765902800
Pk__Key1CLUSTERED11770892IN_ROW_DATA19946159568159448157520
Pk__Key1CLUSTERED11770892ROW_OVERFLOW_DATA0000
DK_2NONCLUSTERED11770892IN_ROW_DATA5834466724655244912
And after:
Pk__Key1CLUSTERED11770892LOB_DATA845812936766503446765902800
Pk__Key1CLUSTERED11770892IN_ROW_DATA19946159568159448157520
Pk__Key1CLUSTERED11770892ROW_OVERFLOW_DATA0000
DK_2NONCLUSTERED11770892IN_ROW_DATA5834466724655244912
And after the index rebuild:
Pk__Key1CLUSTERED11770892IN_ROW_DATA10915873208727286392
DK_2NONCLUSTERED11770892IN_ROW_DATA2546203682031220240
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)