Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Backup log file issue
Howdy, No problem!! Why not use xp_cmdshell? You can use this inbuilt command extension to perform batch type operations in your scripts; Backup Log MYDB to disk = 'D:\Backup\MYDB.log' exec xp_cmdshell 'Net Use z: \\Server\Share' exec xp_cmdshell 'Copy d:\Backup\MYDB.log z:\' exec...- SinThetik
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Top N Statements - Performance Considerations.
Hey vongrunt, Thanks for the advise!! My query finally came back and the execution plan clearly shows the intorduction of the lazy writer and a massively different plan altogether. I'll work on your suggestions and see what comes up! Thanks!- SinThetik
- Post #3
- Forum: Microsoft SQL Server: Programming
-
can i run a stored proc (and use its return value) in an insert
Hi Jasper, There are many ways to skin a cat, and here are 2. For your purposes I would really recommend using the function.. though it would depend where you're getting your @@Identity from, I assume your proc must do something? Functions can be limiting, if the function doesn;t work for you...- SinThetik
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Top N Statements - Performance Considerations.
Hi guys. Got a weird one I'm trying to work out... Selecting top N from a view which has thousands of applicable records. If I top 700 I get results in 4 seconds, if I top 750+ they never return - So I can't even get a query plan back to see what's different between the 2. My "where" clause...- SinThetik
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
