Sorry, I could not follow your question. I do not have any data to test what you are asking and I cannot generate data on my side either. May I...

Replace your hard coded Date values by the respective DATEADD..

For 1 Week Use

ProcessedDatetime > DATEADD(DD,-7,GETDATE()) and ProcessedDatetime < GETDATE()

For 15 Days Use

SELECT DATEADD(DD,-15,GETDATE()) and ProcessedDatetime < GETDATE()

For...

You are Welcome 🙂

SELECT @@VERSION

AND

SELECT 'HELLO WORLD'

These are the kinds of statements that are on top of my head...

Mani-584606 (5/21/2010)

Hi,

I trying to download SQL Server 2008 software and I can see that SQL Server 2008 & SP1 together. So is that mean when I install the setup, after...

Thanks Jason...

Hi...

You need to shrink the database when there is any large data trunacations / deletes.

Use DBCC ShrinkDatabase command to do this..

You can do it from SSMS also..

Read more details...

It would be better if you can find it from the DBA who created the database.

Without any...

It is hard to predict to without knowing what system specs you have.

I just found out on...

Before jumping to Shrink the Files be aware that shrinking will increase fragmentation.

What is the actual size of the data and log files and how much of that is...

I guess that was Enterprise Edition, right? I was trying on SQL Server 2012 R3 128 Bit Version.:-D in which that command is not supported..

Jason, It did not work in my server, what version are you using ?

I am interested to know what are those system tables.

Jason is right. Shrinking the log file will make the log file smaller in size. It is only suggested to shrink the log file to the Max size you might...