Viewing 15 posts - 11,956 through 11,970 (of 22,214 total)
LutzM (8/25/2011)
do you really refer to the number of rows being returned?
Example: a query returning 100K rows should benefit from parallelism but the very same query expanded by a TOP...
August 25, 2011 at 7:36 am
Ninja's_RGR'us (8/25/2011)
Grant Fritchey (8/25/2011)
Rajo (8/25/2011)
thanks for your replies.yes , i executed sys.dm_os_wait_stats and found the following has high wait time
CXPACKET
LAZYWRITER_SLEEP
SQLTRACE_BUFFER_FLUSH
SOS_SCHEDULER_YIELD
how to clear these wait types
thanks
CXPACKET waits are usually an indication...
August 25, 2011 at 7:18 am
For every key press? Whoa! You might want to explore one of the NoSQL options to see if they can support you better. SQL Server is likely to barf at...
August 25, 2011 at 7:13 am
Ninja's_RGR'us (8/25/2011)
How did yo come up with that 10K suggestion?
Basically, wet my finger, stick it in the air, see which direction the wind is blowing...
I've seen benefits with larger data...
August 25, 2011 at 7:12 am
Rajo (8/25/2011)
thanks for your replies.yes , i executed sys.dm_os_wait_stats and found the following has high wait time
CXPACKET
LAZYWRITER_SLEEP
SQLTRACE_BUFFER_FLUSH
SOS_SCHEDULER_YIELD
how to clear these wait types
thanks
CXPACKET waits are usually an indication of parallelism running...
August 25, 2011 at 7:09 am
Automatic update of statistics occurs as the data changes. After an update the stats will update as the indexes are accessed. If you're not seeing updated statistcs, those indexes haven't...
August 25, 2011 at 7:07 am
Did you start a transaction on the client side and is it committed?
August 25, 2011 at 6:49 am
You have to monitor the server to identify what is running slow. As a quick and dirty start point, take a look at the wait states to see what things...
August 25, 2011 at 6:48 am
Parallelism is not something that simply occurs in SQL Server. It's based on two things, the cost threshold you have set for parallelism. By default this value is 5. Personally,...
August 25, 2011 at 6:45 am
Basically that's generating a "SELECT *" statement for every table that you define. Which means it selects everything, every time. It's just going to get slower and slower as your...
August 25, 2011 at 6:39 am
There is something in 2008R2 called Master Data Services, but the strictures for using it were so severe we couldn't get it to fly within our environment. We went the...
August 24, 2011 at 11:43 am
Welsh Corgi (8/24/2011)
I did not mean to offend you.I did not mean it that way.
No offence at all. I was joking. Sorry that came off harsh. It sure wasn't meant...
August 24, 2011 at 11:42 am
Welsh Corgi (8/24/2011)
Grant Fritchey (8/22/2011)
Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008 Internals and just started reading.
If they thought you...
August 24, 2011 at 10:57 am
Oh yeah, it's going to block.
It's all about choices. You want to get rows back and not fall into the crack between a delete and an insert... gotta have the...
August 24, 2011 at 10:56 am
You're trying to build an index off of a field or fields that is too large. You have to use less or smaller fields to build the index. There is...
August 24, 2011 at 9:55 am
Viewing 15 posts - 11,956 through 11,970 (of 22,214 total)