Viewing 15 posts - 41,356 through 41,370 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 28, 2009 at 6:02 am
DBADave (1/28/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 11:30 pm
ScottPletcher (1/27/2009)
It looks to me like SQL is using the non-clus index on the lookup table.
If you look at the exec plan, you'll notice it's a table scan on the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 4:39 pm
Just a note for the future. Please post SQL 2000-related questions in the SQL 2000 forums
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 4:37 pm
kevinsql7 (1/27/2009)
When you back up a sql server database and then restore it, is the restored database more efficient (as far as querying)?
No.
Does a simple backup (without any options...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 1:20 pm
James Zhang (1/27/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 1:16 pm
Viewing 15 posts - 41,356 through 41,370 (of 49,552 total)