This will work OK no matter what the setting for DATEFIRST is:

select

DATE,

WeekStartDate = dateadd(dd,(datediff(dd,'17530107',a.DATE)/7)*7,'17530107')

from

(

selectDATE = getdate()union all

selectDATE = getdate()-7union all

selectDATE = getdate()-(7*2)union all

selectDATE = getdate()-(7*3)union all

selectDATE = getdate()-(7*4)

) a

order by

a.DATE...

You can set the initial size of the data and log files in the CREATE DATABASE statement:

CREATE DATABASE Sales

ON

( NAME = Sales_data,

FILENAME = 'D:\MSSQL\Data\Sales_data.mdf',

...

Approximate numbers, but close enough.

Count Version

----- --------

5 7.00

160 2000

140 2005

40 2008

10 2008 R2

We have a...

I doubt that you can kill it. You will probably have to restart SQL Server.

According to SQL Server 2008 R2 Books Online topic "Report Server Database":

http://technet.microsoft.com/en-us/library/ms156016.aspx

"...

Report Server Temporary Database

Each report server database uses a related temporary database to store session and execution data,...

This script should help you shrink the data files. However, shrinking the data files will cause a lot of index fragmentation, so you should defragement or reindex all the...

Cadavre (9/30/2011)

---

Michael Valentine Jones (9/30/2011)

---

Here is a fairly simple check that will work with any setting of DATEFIRST:

select

a.dt,

IsValidDateTime =

case

-- Check that date string is in correct format, mm/dd/yyyy hh:mm:ss

when dt...

Here is a fairly simple check that will work with any setting of DATEFIRST:

select

a.dt,

IsValidDateTime =

case

-- Check that date string is in correct format, mm/dd/yyyy hh:mm:ss

when dt not like '[0-1][0-9]/[0-3][0-9]/[1-9][0-9][0-9][0-9] [0-2][0-9]:[0-5][0-9]:[0-5][0-9]'

then...

What exactly do you mean by "julian time"?

I have never heard of a definition of Julian Date (or time) that would convert 24701 to 11:53:46.

Without know (or guessing) what unit...

If yout have any input into how the application is coded, you should also look into why there is such a high percentage of single-use plans and if you can...

That is a very complicated subject, and is certainly not as simple as your vendor stated. You should read this article before taking any action.

A SQL Server DBA myth...

aflores1-976495 (9/15/2011)

---

I'm looking for a TSQL cmd for SQL 2008 R2 that essentially does what these TSQL cmds do below for SQL 2005. xp_sqlmaint has been discontinued w/SQL 2008.

Basically Transaction...

This one is fairly short and I did a lot of testing to verify it works OK:

ISO Week of Year Function

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60510

This has the week and day of week included:

ISO Year...

OK, thanks for the info.

"!=" is another way of forming a "not equal" operator, like "<>".

"!=" is not ISO standard, so it is better to use "<>".