Viewing 15 posts - 1,231 through 1,245 (of 3,221 total)
jcrawf02
You attending or presenting ?
SQLSaturday #75 - Columbus 2011 on Jun 11, 2011
May 10, 2011 at 10:49 am
Kathy Cowens (5/9/2011)
May 9, 2011 at 3:35 pm
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...
May 6, 2011 at 3:48 pm
Jeff Moden (5/3/2011)
mtassin (5/3/2011)
WayneS (5/3/2011)
ChrisM@home (5/3/2011)
Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.
+10!
Yes,...
May 4, 2011 at 7:01 am
SQLMyFriend (5/3/2011)
So should we just keep the colllation of what the older server have in the upgrade process?Thanks
Only you can make that decision. My moto is "If it is...
May 3, 2011 at 10:32 am
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...
May 3, 2011 at 10:22 am
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
May 2, 2011 at 8:17 pm
These scripts appear to work correctly, but do not return a time value.
http://www.sqlservercentral.com/scripts/Miscellaneous/31225/
May 2, 2011 at 9:41 am
WayneS (5/1/2011)
BTW, I'm aghast --- you've actually used a SQL...
May 1, 2011 at 4:01 pm
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...
May 1, 2011 at 9:59 am
Steve nice to see all your studying for MCM is turning up in the QODs of late.
April 30, 2011 at 7:05 pm
Hopefully this article by Jeff Moden, will give you a starting point for what you need to do.
April 30, 2011 at 2:39 pm
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...
April 30, 2011 at 2:22 pm
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...
April 30, 2011 at 1:58 pm
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...
April 29, 2011 at 5:55 pm
Viewing 15 posts - 1,231 through 1,245 (of 3,221 total)