Viewing 15 posts - 34,336 through 34,350 (of 49,552 total)
Tara-1044200 (1/29/2010)
can we beleive some online question banks which gurantee passing exams ?
Many of those are braindumps. Actual questions taken from the exams in violation of the NDAs that anyone...
January 29, 2010 at 5:42 am
vbprogrammer1986 (1/28/2010)
table variable always take...
January 29, 2010 at 5:38 am
SQL manages the buffer pool, you cannot control what's in there or on disk.
SQL will try, as far as possible, to keep temp tables and table variables in memory because...
January 29, 2010 at 5:34 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic855810-1550-1.aspx
January 29, 2010 at 5:32 am
You've got nested transactions. With nested transactions, all a commit does is decrement @@trancount until it reaches 0, then the transaction is actually committed. A rollback however will always roll...
January 29, 2010 at 5:30 am
You're updating 50 000 rows in a single transaction? That's gonna cause the log to grow. The log will have to be big enough to store the before and after...
January 29, 2010 at 5:24 am
January 29, 2010 at 5:23 am
Nothing can be denied to a sysadmin.
You need encryption here, but not using SQL Server's certificate-based encryption. The sysadmins will have full rights to the certificates and hence will be...
January 29, 2010 at 5:21 am
No, if you group by the course date, you're asking for the minimum course name PER course date.
Your requirements are not clear.
Do you want the minimum course name per date?...
January 29, 2010 at 5:19 am
It's not since the last SQL start, it's since the last database start. If the DB is closed, taken offline, detached or restored, those stats are also cleared. Watch out...
January 28, 2010 at 10:25 pm
Apollo74x (1/28/2010)
Also - nice blog:http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
Thanks. (It's my blog in case you didn't realise)
January 28, 2010 at 10:19 pm
Apollo74x (1/28/2010)
I'm slightly confused on your question of if the columns are in the same order. I probably confused you in my description.
I missed that the index was on...
January 28, 2010 at 2:03 pm
Apollo74x (1/28/2010)
January 28, 2010 at 1:44 pm
ALTER VIEW <ViewName>
AS
<Entire select statement here>
January 28, 2010 at 12:59 pm
Lynn Pettis (1/28/2010)
GilaMonster (1/28/2010)
CirquedeSQLeil (1/28/2010)
We meet second Thursday of each month. Pacific Time zone.
Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm,...
January 28, 2010 at 11:05 am
Viewing 15 posts - 34,336 through 34,350 (of 49,552 total)