Viewing 15 posts - 38,281 through 38,295 (of 49,571 total)
How many rows are in the table Loja_Venda? Exec plan gives estimated 2.3 rows, actual 15 million, and that's for the results of an index scan with a predicate on...
June 22, 2009 at 3:31 pm
sarvesh singh (6/22/2009)
I'll read up more on this and do some tests on our test server before using it in live systems.
Don't use hints unless you are absolutely, totally, 100%...
June 22, 2009 at 2:58 pm
In most cases, SQL will only use a single index per table to satisfy a query. So, let's say that there's a query with a where clause like this
WHERE phone...
June 22, 2009 at 2:17 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic739638-146-1.aspx
June 22, 2009 at 2:10 pm
jimmycjen (6/22/2009)
I noticed the backup file size is always smaller than the actual database file.
Because the database file may have some empty space and the backups just contain the...
June 22, 2009 at 2:05 pm
sarvesh singh (6/22/2009)
for e.g in the below query what does the merge join do?
Force SQL to use a MERGE join to join the tables, regardless of whether a merge, loop...
June 22, 2009 at 2:03 pm
Grant Fritchey (6/22/2009)
Oh, lordy. That's too much like work. After about the third SELECT DISTINCT, I lost interest.
There are three select DISTINCT in there? I didn't even look that far,...
June 22, 2009 at 10:19 am
jimmycjen (6/22/2009)
Our database is already 90% fragmented.
Index fragmentation or file-system fragmentation?
Does SQL Server backup removes the fragmentation ?
All SQL backup does is read through the database file and...
June 22, 2009 at 10:19 am
Lynn Pettis (6/22/2009)
Isn't this, optimized cursor an oxymoron?? 😉
Optimised cursor = runs way slower than set-based code
Unoptimised cursor = runs way, way, way slower than set-based code
June 22, 2009 at 10:17 am
Should be about the same either way, providing none of them have an explicit transaction wrapped around the whole lot.
June 22, 2009 at 10:01 am
Anyone want to take a stab at 800+ lines of cursor-ridden, mostly uncommented code?
June 22, 2009 at 9:57 am
sarvesh singh (6/22/2009)
I am not clear what Query hints and table hints do? When are they used?
Have you looked in SQL's Books Online? There's a relatively good description of all...
June 22, 2009 at 9:48 am
chris_wallace_000 (6/22/2009)
Thanks SSChampion - will do.
Who are you talking to? 😉
SSChampion is a forum title, like yours is "Forum Newbie"
June 22, 2009 at 9:39 am
Gaby Abed (6/22/2009)
A deadlock is where two blocks can't make nice (they block each other), and SQL Server kills the one that is taking up less resources?
That's one of...
June 22, 2009 at 9:14 am
I'm not an expert on IO or hardware.
Was there a hard power failure? If the caches aren't properly battery-backed, that can cause problems.
Make sure that the HBA drivers are...
June 22, 2009 at 9:12 am
Viewing 15 posts - 38,281 through 38,295 (of 49,571 total)