GilaMonster (3/28/2013)

---

Just a quick comment on the process, not the query...

Unless you've taken the full backup WITH CHECKSUM, the verifyonly verifies very little of the backup and can easily verify...

The answer to both questions is yes.

However, you could also do the insert so it does not fail on the PK violation:

insert into MyTable

select

MyStage.*

from

MyStage

left outer join

MyTable

on

MyStage.PK_Col1 = MyTable.PK_Col1 and

MyStage.PK_Col2 =...

I run DBCC CHECKDB daily on all databases when I can or at least weekly if the maintenance window is too small to do it daily. I have...

If the client can't accept paying for the hours you work, then it's time to move on.

Just turn in your timesheet with the actual hours you work, and let the...

I usually do it this way, because once the database is dropped there is no way to connect to it.

use master;

alter database [MyDb] set offline with rollback immediate;

alter database [MyDb]...

I suggest not giving people permissions to do backups, ands setup a job they can execute that does the copy only backup.

Dynamic SQL is the usually the best way to go when you need to do catch-all searches with multiple optional parameters.

Don't underestimate...

Did you verify that Excel is installed on the machine you are trying to execute the SSIS package on?

I don't see the value in using Litespeed for backups, since the native backup compression in 2008 EE is just as good and doen't cost anything.

Or find a vendor that knows what they are doing with SQL Server. :crying:

If this is an application that is connection pooling, then that can cause other problems in...

dhananjay.nagarkar (3/7/2013)

---

Hi Lynn,

that will not help since in my case one of the dates can remian NULL hence if that's the case then it will not work using > ,...

In the tests in the article they tested only two HDDs compared to 15 SSDs and they subjected the HDDs to far fewer power loss tests and one of the...

Jeff Moden (2/25/2013)

---

You can also cheat for performance with a little integer math. The 22800 is the year (1900*12). The "0" in the BOM forumula is 1900-01-01. ...

Eric M Russell (2/26/2013)

---

Miles Neale (2/26/2013)

---

Dave62 (2/26/2013)

---

Definitely not.

I do .NET development and SQL...

Champagne Charly (2/23/2013)

---

Hello,

Has any idea why this is classed as non deterministic.

DATEFROMPARTS(DatePart(yyyy,DATEADD(dd, (DATEPART(dw, Date_received) - 1) * - 1, Date_received)),DatePart(mm,DATEADD(dd, (DATEPART(dw, Date_received) - 1) * - 1, Date_received)),DatePart(dd,DATEADD(dd, (DATEPART(dw,...