Viewing 15 posts - 42,016 through 42,030 (of 49,552 total)
What's this function supposed to do?
I'd offer help in getting rid of the cursor, but I have absolutely no idea what it's doing.
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 3, 2009 at 7:26 am
madhu.arda (1/2/2009)
We have data files on D drive and log files on F drive and tempd on G drive and Backups are Z drive
Are those separate physical drives, or partitions...
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 3, 2009 at 7:25 am
branovuk (1/2/2009)
"...A full database backup backs up the whole database. This includes part of the transaction log so that 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 3, 2009 at 7:08 am
Mad-Dog (1/2/2009)
SQL 2005.yes i'm seeing that my tempdb database sometimes grow for 40-50GB.
That's not what I asked. I asked if you're seeing large temp tables that stay around for...
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 2, 2009 at 5:31 am
If you create an inline table-valued function (which you have, by specifying just RETURNS TABLE), it must be a single select statement. If you want control flow, then you need...
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 2, 2009 at 5:02 am
ervin_brosas (1/1/2009)
I need to migrate the database from SQL 2005 to SQL Server 2000.
The only way to do that is to script all of the objects out, bcp all 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 2, 2009 at 4:02 am
talk2riya15 (1/1/2009)
i want to add more column dynamically by using store procedure......how can i do this????
Why do you need to do this?
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 2, 2009 at 2:14 am
Mad-Dog (1/2/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 2, 2009 at 2:05 am
David O (1/1/2009)
Pretty sure now it is the version of Sql and the OS I'm trying to use instead of 32 bit on x64 bit OS.
What edition of SQL...
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 2, 2009 at 12:18 am
GilaMonster (1/1/2009)
Please post table structure (as create table statements), some sample data and your expected results. Read this to see the best way to post this to get quick responses.http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 2, 2009 at 12:15 am
David O (12/31/2008)
I just rebuilt my work station Win x64 ... and the RTM disk tells me my OS isn't supported.
What OS are you using? What edition of SQL...
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 1, 2009 at 2:19 pm
Jeff Moden (1/1/2009)
This is obviously either homework or an interview test.
And it doesn't appear to be particularly urgent.
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 1, 2009 at 2:13 pm
As I asked before, have you read through the sections in Books Online on the encryption hierarchy and how the encryption works?
A very quick google search on EncryptByPassphrase turned these...
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 1, 2009 at 1:50 pm
ALZDBA (1/1/2009)
first read: http://www.sommarskog.se/dynamic_sql.htmlThen : this is certainly not a best practice !
In addition, make sure you know what SQL injection is and how to prevent 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 1, 2009 at 1:45 pm
Just make sure that you have the correct data types in your source table, ie dates are stored as datetimes and the numbers are stored as numeric, decimal or money,...
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 1, 2009 at 12:14 pm
Viewing 15 posts - 42,016 through 42,030 (of 49,552 total)