Viewing 15 posts - 37,501 through 37,515 (of 49,552 total)
http://www.google.com/search?q=backup+%22maintenance+plan%22+site%3Amsdn.microsoft.com
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
July 22, 2009 at 9:04 am
I can't offer useful advice without knowing what the error was and on what command it was raised...
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
July 22, 2009 at 6:33 am
luckysql.kinda (7/22/2009)
Thanks Gila. Is column statistics also needful?
What do you mean by 'needful'?
They're not a deprecated feature, they're essential for the optimal performance of the query engine.
Check Books...
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
July 22, 2009 at 6:30 am
In the Generate Scripts wizard, on the options page, change the server version for the script to SQL 2000.
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
July 22, 2009 at 3:09 am
In the first script you posted, you're missing the \ on the drive letter. You have D:BackUpYourBaackUpFile.bak instead of D:\BackUpYourBaackUpFile.bak The error message indicates that that's a problem with 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
July 22, 2009 at 2:46 am
Excellent!
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
July 22, 2009 at 2:24 am
What precisely do you mean by 'doesn't work'? What part doesn't work, what error does it throw or what does it do that it shouldn't be 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
July 22, 2009 at 1:24 am
Since you're on SQL 2005, use sys.indexes rather than the old sysindexes. sys.indexes contains only indexes, sysindexes can contain the column statistics as well.
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
July 22, 2009 at 1:18 am
Please don't start multiple threads for the same problem.
Asked and answered: http://www.sqlservercentral.com/Forums/Topic757156-145-1.aspx
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
July 22, 2009 at 1:16 am
I can't see any reason why that would be deadlocking then. Can you post the exec plan of one of those inserts? (saved as a .sqlplan file, zipped and attached)
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
July 22, 2009 at 12:19 am
Triggers fire when some data in the table is changed. If you need something that runs at a certain time of the day, you need a SQL Agent job.
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
July 22, 2009 at 12:18 am
Ankur Bajaj (7/21/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
July 21, 2009 at 4:52 pm
Bruce W Cassidy (7/21/2009)
Paranoia is the one I remember ("The Computer is your friend!")
Never played it, but I would like to try it sometime.
Switching back and forward between 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
July 21, 2009 at 4:49 pm
Why can't you go and speak to them, explain why what they're doing is harmful (lay down the recovery consequences) and ask them to stop. That would be my first...
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
July 21, 2009 at 4:44 pm
. (7/21/2009)
What kind of roleplaying game involves conspiracies, Gail?
Lots. Dungeons and Dragons may be the best known, but it's far from the only one. Many of the World of Darkness...
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
July 21, 2009 at 4:25 pm
Viewing 15 posts - 37,501 through 37,515 (of 49,552 total)