Viewing 15 posts - 46 through 60 (of 80 total)
jared-709193 (9/26/2011)
With tens of millions of rows... What is the data type for the column of your clustered index? Is it identity insert?Thanks,
Jared
Jared, we're well beyond 10s of millions, as...
September 26, 2011 at 3:10 pm
Ive gotten some REALLY good help from them in the past. On occasion though, it takes a few rounds of engineers to get the help I need... Ive been...
September 26, 2011 at 3:08 pm
and I opened a case with M$ support to see if they can make heads or tails of it.
reaction after the first 90 minute call was "HMmmmmmmmmmmmmmm" :w00t:
September 26, 2011 at 2:57 pm
we autogrow by 10%, BUT monitor file free space and manually grow files in advance of an autogrow occuring.
We have a primary file group with one primary data file...
September 26, 2011 at 2:55 pm
The plot thickens,.
another table on the same server, different database exhibiting the EXACT same conditions.
September 26, 2011 at 2:00 pm
another (probably useless) tidbit...
sys.sysdatabases and sys.databases are not the same! I just spent 5 minutes trying to figure out why I couldnt validate snapshot isolation levels in sys.sysdatabases... one...
September 22, 2011 at 12:00 pm
Ninja's_RGR'us (9/22/2011)
LAW1143 (9/22/2011)
none of the indexes on this table have been rebuilt or...
September 22, 2011 at 11:47 am
okbangas (9/22/2011)
Do you have a clustered index? If so, is it unique? Otherwise, updates can cause page splits. Aborter possibility, have you recently started to use row versioning (snapshot isolation)?
there...
September 22, 2011 at 11:38 am
great thought, and I should have included that in the 'what I know' portion of my first post...
none of the indexes on this table have been rebuilt or reorganized lately,...
September 22, 2011 at 11:33 am
thanks for the reply, but this was a thought I had as well and already ruled out. what was null then is null now.
its tied to a specific...
September 22, 2011 at 11:29 am
the quickest dirtiest way is to look at the size of your data file(s). SSMS doesnt reflect increases in tempdb size. its available in the DMVs, but just...
September 22, 2011 at 11:04 am
There are 6 or 7 of them, all in the 25 to 40gb range.
Rebuilding the clustered index will hit all non clustered indices, but I'm not sure if it needs...
July 15, 2011 at 4:50 pm
theres alot of lines of code there! 😮 more than I'll have a chance to digest for a while!
we've got a table thats been largely purged, and to recover...
July 15, 2011 at 2:22 pm
Perry Whittle (7/15/2011)
what recovery model is your database using?
by default, full.
if I absolutely MUST switch to simple, its not the end of the world. but I'd like to avoid...
July 15, 2011 at 1:57 pm
In the two scenarios I recall most closely of this, neither case could hvae been parameter sniffing.
in the first, the proc does not have any parms. its used for the...
May 20, 2011 at 9:56 am
Viewing 15 posts - 46 through 60 (of 80 total)