jcrawf02

You attending or presenting ?

SQLSaturday #75 - Columbus 2011 on Jun 11, 2011

Kathy Cowens (5/9/2011)

---

Thanks - I have grown the file twice, once by 20000MB and once by 50000MB. I'll take a look at table sizes and review the initialization setting....

Please note:

1) Index rebuild works by re-creating the index internally again and when that has been achieved, it drops the existing index where as index reorganize is the process of...

Jeff Moden (5/3/2011)

---

mtassin (5/3/2011)

---

WayneS (5/3/2011)

---

+10!

Yes,...

Only you can make that decision. My moto is "If it is...

Using OPENROWSET

The example below has this capablity

it reads data from Sheet1 starting at row 4 and only imports data form colums a thru c

If the Excel sheet does not have...

Might this help you

Latin1_General_CI_AS :- Latin1-General, case-insensitive, accent-

sensitive, kanatype-insensitive, width-insensitive

SQL_Latin1_General_CP1_CI_AS:- Latin1-General, case-insensitive,

accent-sensitive, kanatype-insensitive, width-insensitive for Unicode

Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

These scripts appear to work correctly, but do not return a time value.

http://www.sqlservercentral.com/scripts/Miscellaneous/31225/

WayneS (5/1/2011)

---

Jeff, I had to rate this article 5 stars, because that's as high as the ratings allow. It deserves a 15!

BTW, I'm aghast --- you've actually used a SQL...

Here is a quick and easy way for you to answer your own question.

Run Google, paste in the search box "sql server set ansi_warnings on"

and then read one or more...

Steve nice to see all your studying for MCM is turning up in the QODs of late.

Hopefully this article by Jeff Moden, will give you a starting point for what you need to do.

http://www.sqlservercentral.com/articles/T-SQL/71550/

Simply type Denali in the window in the upper right hand corner of this forum screen and then click on "go" button to its right.

You will find 171 items that...

To assist you in planning your migration read this article and determine which method would be most suitable for your situation.

http://www.sqlservercentral.com/articles/Administration/2987/

I would strongly suggest reading the section on the "Upgrade...

Reported a posting (today) as an advetisement and look what I got back.

I am currently out of the office, I will be back on Tuesday 3rd May.

If the matter is...