Viewing 15 posts - 37,261 through 37,275 (of 49,552 total)
Rajesh kasturi (8/7/2009)
I am just searching find alternate ways to recover for different scenario.There might be solution
Answer my questions about what you're doing with the transaction log and I'll...
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
August 7, 2009 at 2:55 am
Did you specify the restore must be done WITH STANDBY?
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
August 6, 2009 at 2:46 pm
Edit: Nevermind. Must read posts more carefully in future.
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
August 6, 2009 at 2:46 pm
Yeah but likes with leading wildcards will always, in the absence of other SARGable predicates do a full index/table scan
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
August 6, 2009 at 1:09 pm
Grant Fritchey (8/6/2009)
Jeff Moden (8/6/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
August 6, 2009 at 1:08 pm
Remove the 'd'? (Why's it there in the first place?)
Cast to float then to decimal?
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
August 6, 2009 at 12:59 pm
If you've backed up the system databases (specifically master and msdb) and restored those, the system will be as it was at midnight. If you haven't backed up the system...
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
August 6, 2009 at 12:37 pm
It was a feature added in SQL 2005 for cases where an index needs to be dropped for data loads. It means that the index can be recreated without needing...
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
August 6, 2009 at 12:35 pm
select message_id, severity, text from sys.messages where language_id = 1033
As for custom errors, from the Books Online entry for RAISERROR
msg_id
Is a user-defined error message number stored in the sys.messages...
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
August 6, 2009 at 12:31 pm
Jeff Moden (8/6/2009)
I may have the wrong boy. I've posted a question to him to find out.
I suspect you do have the wrong guy.
karthikeyan: http://www.sqlservercentral.com/Forums/UserInfo151404.aspx (today's poster)
karthikeyan: http://www.sqlservercentral.com/Forums/UserInfo449952.aspx (PhD...
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
August 6, 2009 at 12:07 pm
Chris Harshman (8/6/2009)
DUMP is a desupported feature, and Microsoft plans on removing it
Dump is gone in SQL 2008.
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
August 6, 2009 at 10:57 am
Try switching the table variables to temp tables, see if that make a difference.
If it doesn't, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Also, is that...
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
August 6, 2009 at 9:35 am
Not a bug.
Isnumeric returns true if the value passed can be converted to any of the data types.
select CAST('0.d00' as float)
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
August 6, 2009 at 9:34 am
Tell your colleagues that they should check with people before restoring backups.
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
August 6, 2009 at 6:29 am
Only if you have a backup.
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
August 6, 2009 at 5:56 am
Viewing 15 posts - 37,261 through 37,275 (of 49,552 total)