theBorch (1/31/2011)...

This DBA is very reluctant to give that consultant Windows & SQL sysadmin rights to the University's SQL cluster that is housing their sensitive DB's, on account that said...

YSLGuru (1/31/2011)

---

Michael Valentine Jones (1/31/2011)

---

I go with "Don't ask, don't tell".

We have about 300 instances of SQL Server Express/MSDE/etc. that I know of, so I just leave them alone.

I have...

I go with "Don't ask, don't tell".

We have about 300 instances of SQL Server Express/MSDE/etc. that I know of, so I just leave them alone.

I have enough to worry about...

You can just add them together. Example:

select

a.[Date]+a.[Time] as DatePlusTime,

a.*

from

...

By default, BCP loads everything in one transaction, so your transaction was 443 million rows and your transaction log file had to grow to hold that.

Use the BCP batch size...

The script executes on the SQL server, not the client, and SQL Server has no knowledge of the timezone setting of the client, so the time of getdate() will be...

When you expand a log file SQL Server has to initialize it internally, and that is what takes more time.

When you expand a database data file, that is not necessary,...

select

*

from

MyTable

where

--Equal to or greater than start of yesterday

MyDate >= dateadd(dd, datediff(dd, 0,getdate())-1,0)and

--Less than start of yesterday

MyDate < dateadd(dd, datediff(dd, 0,getdate()),0)

Eric M Russell (1/27/2011)

---

TravisDBA (1/27/2011)

---

Michael Valentine Jones (1/26/2011)

---

"Small minds copy ideas but great minds steal them outright and make them their own."

Or something like that, can't remember exactly where...

The real problem is that there is no universal answer, since the offset changes at least twice per year in places that observe daylight saving time, and the rules for...

You may want to look into SSD storage. For example, this product promises 6 GB/Sec of bandwidth on a 5 TB device.

http://www.fusionio.com/products/iodriveoctal

With 10 units, you would have 60...

william-700725 (1/27/2011)

---

[font="Courier New"]About time somebody pointed out the convenience of the standardized formats. I've been using UCASE( CONVERT( char ( 11 ) , GETDATE() , 106 ) ) to create...

"Small minds copy ideas but great minds steal them outright and make them their own."

Or something like that, can't remember exactly where I stole that line.

I have posted a...

PHXHoward (1/24/2011)

---

Thanks Michael and others.

Michael, I was able to make your script work in 2008 by adding some additional fields to the temp tables.

I would like to execute the...

SharePoint stores files in a SQL Server database. I haven't tried saving an MP3 in Sharepoint, but I know that we have used it to store training videos, so...