You can use this thing

i think this will definately work.

CREATE PARTITION FUNCTION TwoYear(datetime)

AS

RANGE LEFT FOR VALUES

('01-'+substring(convert(varchar,getdate(),105),4,11)+' 00:00:00.000',

'02-'+substring(convert(varchar,getdate(),105),4,11)+' 00:00:00.000',

'03-'+substring(convert(varchar,getdate(),105),4,11)+' 00:00:00.000',

'04-'+substring(convert(varchar,getdate(),105),4,11)+' 00:00:00.000',

'05-'+substring(convert(varchar,getdate(),105),4,11)+' 00:00:00.000',

'06-'+substring(convert(varchar,getdate(),105),4,11)+' 00:00:00.000',

'07-'+substring(convert(varchar,getdate(),105),4,11)+' 00:00:00.000')

For more Info visit:

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

create a Partition Function like the below mentioned code

In below mentioned function the range is based on month & all you need to do is to convert it to dates,...

See there can be ideal values for some Counters i.e. Avg. Disk Queue Length etc. but if you talk abt ideal value for all of them i would say that...

There is a setting in the configuration Manager by which you can hide an instance, see if this has been configured.

IF not I know this may sound very obvious but...

This process involves sequentially upgrading the instances of Microsoft SQL Server 2005 that are participating in database mirroring. This form of upgrade, which is known as a rolling upgrade, reduces...

You can also use sp_tables

Start the System Control panel applet (start - settings - control panel - system)

go to avanced tab and then Click Performance settings

Now again go to advanced tab

Under the...

You can also use sp_msforeachdb and still exclude some DBs, heres a script for the same:

EXEC sp_msforeachdb '

IF ''?'' IN ( ''db1'', ''db2'', ''db3'', ''db4'' )

...

Hey thanks Scott. This can be useful in many ways.

If you want to copy a file from a Server to another server you can use this command.

master..xp_cmdshell 'xcopy G:\SMSDTH2003_Diff_backup\SMSDTH2003_Diff_backup_latest\DIFF_Backup.sqb \\172.16.6.249\j$\SMSDTH2003_Diff_backup\SMSDTH2003_Diff_backup_latest\'

That's good, but we already have an inbuilt feature which is giving much more flexibility than this tool. why i should use it?

I would appreciate if you can just list...

Increase the Page File of the system where you are executing these queries and then try again.

you can set the Page File of a system to 1.5 times of the...

As per Microsoft, This problem occurs because the Windows operating system pages out the working set of the SQL Server process.

These error messages are logged when the working set of...

See when you are setting the max memory setting the service will pick the max mem. at the time of startup, no matters whether it needs it or not.

whereas if...