Environment: SQL Box: Windows Server 2008, SQL Server 2008 Std App Box: Windows Server 2008 I have one SQL and one App server. I've been asked to...
There are many unused databases in my DEV and QA environments. The space they take is about 700 MB. So, wouldn't be much saving in space if I drop...
Is there any estimate when Denali would be launched?
There is a stored procedure in one of DBs (and the DB size is about 70 GB) which is as below. SELECT ... FROM {Inner Join of 10 tables and views}...
I need to script everything related to a table except the table itself. I don't need CREATE TABLE but need to generate scripts for constraints, FKs,...
I have a 1TB database that inherited. The database has 1 mdf file, 55 ndf, and 1 ldf. It is set to simple recovery mode. The database is on a SQL...
I want to see SQL Database and Network security event log settings. How can I do that?
I have a Scheduled batch file that copies BAK files from prod into DR box (in another country) every night starting at 8pm. There is a SQL job in DR...
During the night I have BAK file transfer to a Test machine and restore. The restore program fails when executes “RESTORE FILELISTONLY FROM DISK“...
I know there are tools that squeeze SQL backup on the air. And I know SQL 2008 has the backup compression built in. But I am looking for a way to...
SQL Server 2k5 64bit version: 9.0.4035 I have a maintenance plan to delete BAK files older than 2 days. The job starts at 8:30pm everyday. But I see...
This is weird. This command SELECT * INTO [TempDB..T1] FROM [MyDB].[dbo].[T1] Creates a table in TEMPDB as “TempDB..T1â€!! This is the table...
I have a SQL 2005 server which was built from scratch. The databases on this machine were restored from a SQL 2000 server and the server was...
Using a DTS package, I update SQL jobs in DR box with jobs from prod. This is scheduled and runs automatically. It works fine but imports only the...
In order to build a DR box, the plan is to transfer database backups and restore in DR every night. This specific production server has databases...
One of my SQL 2000 servers has started a weird attitude since last week. Its version is 8.00.2039 (SP4) on a Windows Server 2003 R2 Standard Edition...
Does only running a SELECT statemnet updates Last_Batch in master.dbo.sysprocesses?
I am building some DR boxes and want to copy DBs, jobs, logins and everything from prod into initial DR box. For SQL 2000 I used to stop prod and...
How can I change the default backup folder in a SQL 2005? I think at the time of installation it is set to D:somewhere and I want to change it to...
DBCC CHECKCATALOG returns a set of rows like the following. Check Catalog Msg 3853, State 1: Attribute...
Separate names with a comma.
