Search Results | SQL Server Performance Forums

SQL Server 2008 book

Thread by: ashish287, Jul 18, 2009, 1 replies, in forum: SQL Server 2008 General DBA Questions

Hi Friends, Can someone please suggest which book is best for sql 2008 contains :- 1) Administration troubleshooting 2) New features 3) Any ebook...

Need a query to get the record

Thread by: ashish287, Nov 7, 2008, 4 replies, in forum: General DBA Questions

Hi Friends, I have table xyz in all the user database. Now my query is :- The table xyz is having column pqr, I want to select the record from...

how to take the command prompt result in html file

Thread by: ashish287, Sep 17, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi Friends, Every night we have to check the space available on all database related drive for all the 16 server. So I am taking this result with...

How to auto split the zipped backup files

Thread by: ashish287, Jun 19, 2008, 3 replies, in forum: General DBA Questions

Hi Friends, I have a folder in my database server where every night my 56 backup files copied for that server. And then there is aut schedular which...

help to create one cmdexec job

Thread by: ashish287, Jun 9, 2008, 4 replies, in forum: General DBA Questions

Hi Friends, I am creating one sql job for cmdexec to delete all the files in a perticular folder. But as from command prompt it ask for confirmation...

My Database job failing every first day of the month

Thread by: ashish287, Apr 2, 2008, 4 replies, in forum: General DBA Questions

Hi All, Please suggest.. I have 7 step in my Database job which run every day on server. But all my similar database jobs are failing on first step...

Cluster service is going to Hung state

Thread by: ashish287, Mar 13, 2008, 1 replies, in forum: General DBA Questions

Hi, I have a cluster on two node as ACtive Passive and the problem is its going to hung. Not sure about the reason. What I can troubleshoot and want...