At least 92,045 terabytes is below the maximum database size of 524,272 terabytes, but you would need to have at least 5,753 files in tempdb at a maximum of 16...

GilaMonster (7/31/2014)

---

Michael Valentine Jones (7/31/2014)

---

The last vendor I had to deal with had an application that required the use of a specific SA password to connect to the database on...

You...

As a general rule, vendors have very little knowledge of DBA best practices, so they just toss out some misinterpreted stuff that some junior developer found on some web site...

This should do what you need.

Why do you have WAITFOR DELAY '00:00:20' in your sample code?

declare @NextId_output table ( NextId int not null )

UPDATE TableIds

SET

NextId = NextId + 1

output

inserted.NextId...

select [Date] = convert(date,'7/26/29')

Results:

Date

----------

2029-07-26

An example of what?

You haven't really explained your problem well enough for anyone to know what you are asking, and you haven't explained the...

Not sure what decimal you are actually after, but here are some examples of what you might be after.

select

a.CurrentDatetime,

a.CurrentTimeOfDay,

HourOfDay=

convert(numeric(18,4),round(datediff(ms,0,a.TimeOfDay)/3600000.000000,4)),

MinuteOfDay=

convert(numeric(18,4),round(datediff(ms,0,a.TimeOfDay)/60000.000000,4)),

SecondOfDay=

convert(numeric(18,4),round(datediff(ms,0,a.TimeOfDay)/1000.000000,4)),

MillisecondOfDay=

datediff(ms,0,a.TimeOfDay)

from

(

selectCurrentDatetime= getdate(),

CurrentTimeOfDay= convert(time(3),getdate()),

TimeOfDay= convert(datetime,convert(time,getdate()))

) a

Results:

CurrentDatetime ...

ChrisSut (7/25/2014)

---

>>>Why do the different databases need to be in two different countries?

This is a legal requirement, we cannot keep health records of US citizens in Canada or health records...

J.Faehrmann (7/23/2014)

---

That...

This is a sample of a restore command to use after dropping the restore target database:

declare @BackupFile nvarchar(500)

set @BackupFile = '\\MyBackupServer\MyBackupShare\MyBackupFolder\MyTestDBBackup.bak'

restore database [MyTestDB]

from disk = @BackupFile

with

-- Logical names to...

MrG78 (7/23/2014)

---

the ALTER DATABASE....SINGLE_USER method as suggested earlier is a good suggestion. Remember to add the WITH ROLLBACK IMMEDIATE otherwise it will wait for the connection to be closed...

I...

It's simpler if you just drop the test database before starting the restore to prevent it from being in use.

Example:

use master;

-- Set offline to disconnect all users from the database

alter...

Jeff Moden (7/21/2014)

---

SQLRNNR (7/21/2014)

---

Jeff Moden (7/21/2014)

---

Jack Corbett (7/21/2014)

---

SQLRNNR (7/21/2014)

---

I am a bit surprised this hasn't been asked yet and it seems REALLY important.

Why do you have 2000 log...