Viewing 15 posts - 91 through 105 (of 147 total)
[font="Verdana"]Some sign of relief @
http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/
[/font]
April 11, 2011 at 12:19 am
[font="Verdana"]Grant, if following tiny confusion can be explained?
Do DMV/Fs provide "Actual Execution Plan" or "Estimated Execution plan" specially Sys.DM_exec_Query_Plan?
Logically it should be "Actual Execution Plan" rather than "Estimated Execution plan"!...
April 4, 2011 at 1:10 am
GilaMonster (3/22/2011)
Abrar Ahmad_ (3/22/2011)
3. How to get max from modern multi-core processors?
Err, don't understand the question
3. How to get maximum from modern multi-core processors [if for long running queries (and...
March 22, 2011 at 3:19 am
Roger L Reid (5/7/2008)
Now, you'll say "that's bad code - rewrite it". And I'd love to. I love to code, and I can't say I like SQL...
March 21, 2011 at 11:45 pm
What reason did he give for going back to an 11 year old, unsupported product?
I hope you have a backup from before the upgrade, otherwise going back will be...
January 31, 2011 at 3:14 am
Update all statisics with full scan. Turn auto_create on. Then either turn auto_update on or implement a custom statistics maintenance routine.
[font="Verdana"]
1. Do creating statistics on each column is feasible?
2. It...
January 31, 2011 at 2:42 am
Secondly, what u suggest if it is devised to manually create statistics on all table columns after migration/up-gradation, and surely to update Statistics with Full Scan, as problem sql 80...
January 31, 2011 at 2:15 am
GilaMonster (1/31/2011)
January 31, 2011 at 1:10 am
GilaMonster (1/28/2011)
If you mean SQL 2000 to SQL 2008, it's a backup/restore. You do need to test your app thoroughly, as lots changed.
[font="Verdana"]
Yes agreed that there may be some/more...
January 30, 2011 at 10:50 pm
[font="Verdana"]
...
I don't think you can alter the priority for system processes, you could try altering your sessions but I figure that might be risky.
:discuss: how?
In general I want to get...
January 11, 2011 at 4:38 am
sturner (10/8/2010)
October 8, 2010 at 11:52 pm
skcadavre (8/12/2010)
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30222/
[font="Verdana"]Thank you for your time,
but i had gone through this solution before but .... !
My scheme would be to replace this old technique, as we can easily get...
August 12, 2010 at 10:43 pm
CELKO (8/10/2010)
SELECT A.col1, B.col1, A.col2, B.col2
FROM A LEFT OUTER JOIN B
ON A.col1 = B.col1
...
August 11, 2010 at 1:06 am
Eugene Elutin (8/10/2010)
It is kind of LEFT JOIN, but you filtering results for A.COL2 = B.COL2, why bother to have A.COL1 *=...
August 11, 2010 at 12:32 am
[font="Verdana"]I am curious, that no one has yet commented over CDC feature built-in in SQL Server 2008?
It is not such out off the domain of Auditing?
Please?
[/font]
July 23, 2010 at 4:33 am
Viewing 15 posts - 91 through 105 (of 147 total)