Viewing 15 posts - 15,076 through 15,090 (of 49,552 total)
Sean Lange (12/26/2012)
The locking you are seeing is because of lock escalation.
It's not lock escalation.
Truncate table locks at the table level because there's no other sensible level to lock...
December 26, 2012 at 1:04 pm
December 26, 2012 at 1:03 pm
idyana (12/26/2012)
How do I want to make both of them (State and City) is Index Seek?
You can't.
A seek requires something to search for. Something to filter on. Your query requests...
December 26, 2012 at 1:00 pm
It's probably got nothing whatsoever to do with the cached execution plan. The optimiser is not allowed (in most cases) to spend minutes optimising a query.
What's probably causing the slow-down...
December 26, 2012 at 12:56 pm
zi (12/26/2012)
1-1-How to know the fragmentation size for whole database not only for certain table, to decide if it exexceeds 30% to re-build index or re-organise.
Databases don't have fragmentation. Indexes...
December 26, 2012 at 12:53 pm
Box set of Star Trek: The Next Generation DVDs. All seasons.
You guys don't need me for the next month or so, do you?
December 26, 2012 at 12:49 pm
Lynn Pettis (12/24/2012)
Aren't logical reads reads from data cached in memory?
Yes
Would these be good reads as SQL Server doesn't have to go to disk to get the data?
Maybe. 🙂
All...
December 26, 2012 at 12:48 pm
SQLCrazyCertified (12/24/2012)
Some times you need to do log backups couple of times in order for the inactive logs to be truncated.
Not if the DB is in simple recovery, which the...
December 26, 2012 at 12:46 pm
A once-off shrink to a sensible size (not as small as possible), then rebuild all indexes.
December 24, 2012 at 7:07 am
That's perfectly normal, expected behaviour. SQL will use as much memory as it can to improve performance.
If it's using too much, lower max server memory, and inform the windows team...
December 24, 2012 at 5:37 am
Please post your problem in a new thread. Thanks
December 24, 2012 at 5:33 am
You can't just download SSMS (other than the express version). Install it off the SQL Server 2005 installation disks
December 24, 2012 at 1:11 am
Jeff Moden (12/23/2012)
December 24, 2012 at 1:08 am
Dynamic SQL (watch for SQL injection) or a string splitter function. I recommend the latter. Search this site for 'Delimited8kSplit'
Oh, and as for why your attempt failed, that equates to...
December 23, 2012 at 7:33 am
shohelr2003 (12/23/2012)
December 23, 2012 at 2:44 am
Viewing 15 posts - 15,076 through 15,090 (of 49,552 total)