Viewing 15 posts - 41,371 through 41,385 (of 49,571 total)
nabajyoti.b (1/28/2009)
How do i find that it is in full recovery mode?How do i change the recovery model to simple or take a transaction log backup?
Is there a DBA there?...
January 28, 2009 at 7:44 am
Think you could maybe post the code that you're running? Without that I can't begin to guess why you're getting a syntax error.
January 28, 2009 at 7:39 am
Domagoj Orec (1/28/2009)
Ok, maybe not, but it is kinda weird.
Nah. Some people join to post on the forums (and hence gain points), many join just to read (and maybe submit)...
January 28, 2009 at 7:38 am
I would strongly suggest, if this is for a procedure, call sub-procedures instead of hving all the possible selects in the one procedure. There's a big parameter sniffing problem if...
January 28, 2009 at 7:35 am
kiman_keren (1/28/2009)
for question number 2: yup, i wanna know that.
SQL reads the table, gets all the values for the columns that the index key includes, sorts them, allocates pages and...
January 28, 2009 at 7:31 am
Loner (1/28/2009)
Is your company planning to upgrade from SQL Server 2005 to 2008 this year?
I've got clients still on SQL 2000 with no plans to upgrade.
January 28, 2009 at 7:26 am
thatok (1/28/2009)
Now the tables on my side are already encrypted. The process I used last month was rather messy.
How are they encrypted? To use DecryptByKey, the data must have been...
January 28, 2009 at 7:23 am
Grant Fritchey (1/28/2009)
I didn't get to see it. I wish I had.
You didn't miss much. I read about half of it and then gave up
January 28, 2009 at 7:19 am
Are those the only errors that checkDB's returning? If not, can you post the entire output of the following
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Detach/attach will not...
January 28, 2009 at 6:13 am
Steve linked to the original article in his editorial today.
http://www.sqlservercentral.com/articles/career+growth/64632/
The plagiarised article has been removed.
January 28, 2009 at 6:03 am
thatok (1/28/2009)
Argument data type float is invalid for argument 1 of DecryptByKey function.
Indeed it is. Decrypt takes a varbinary parameter, as all encrypted data is varbinary. If it's float, it...
January 28, 2009 at 6:02 am
DBADave (1/28/2009)
January 28, 2009 at 12:32 am
DBADave (1/27/2009)
When adhoc plans are cached how long do they stay in the cache?
Depends on how expensive they were to compile and how often they're used.
Will they be eventually flushed...
January 27, 2009 at 11:47 pm
shivayogigouda.patil (1/27/2009)
How to execute DBCC CheckDb command to remove the consistency errors found in msdb database.Do we suppose to get the database in single user mode?
The preferred way to fix...
January 27, 2009 at 11:33 pm
smeet.sinha (1/27/2009)
Can't we use execute statement in functions?????
No, you can't.
My second question is : How can i store a value returned from execute(tsql) in a variable.
Look up sp_executesql. It...
January 27, 2009 at 11:30 pm
Viewing 15 posts - 41,371 through 41,385 (of 49,571 total)