Viewing 15 posts - 3,991 through 4,005 (of 9,712 total)
SSIS is your best friend for this type of thing. You can actually run a Data Flow task and do a Derived Column Transformation (use a REPLACE()) to get rid...
September 11, 2012 at 5:11 am
Ville Lucander (9/11/2012)
Sorry, I've never heard of "servername@dbname" being a connection string for the native SQL Server connections. So I'm still blank on this.==> this works anyway
Not saying it doesn't....
September 11, 2012 at 5:09 am
Eugene Elutin (9/11/2012)
Brandie Tarvin (9/11/2012)
They are both incorrect syntax. You will get an error if you try to use either of them..
Until
in case #1: Select * from table.col
...
September 11, 2012 at 5:03 am
It is not possible to do a file level partition at this time.
September 11, 2012 at 4:58 am
They are both incorrect syntax. You will get an error if you try to use either of them.
On the other hand, if you're talking about SELECT * FROM TABLE and...
September 11, 2012 at 4:55 am
Sorry, I've never heard of "servername@dbname" being a connection string for the native SQL Server connections. So I'm still blank on this.
Let me ask this, where are the SQL 2000...
September 11, 2012 at 4:49 am
lianvh (9/11/2012)
September 11, 2012 at 4:41 am
Eugene Elutin (9/11/2012)
dwain.c (9/11/2012)
Sean Lange (9/10/2012)
You know simply repeating a vague description does nothing to help me understand it.
"Insanity is doing the same thing over and over again and expecting...
September 11, 2012 at 4:36 am
You can't, really. Where the data resides is a function of the engine and the default filegroup.
The best you can do for control purposes is to either create a...
September 11, 2012 at 4:28 am
Ville Lucander (9/11/2012)
I'm setting up new ETL servers and I might need to install both 2012 and 2008 clients. Because I can't read 2000 server OK with 2012 atleast so...
September 11, 2012 at 4:23 am
I can't see your example. Can you post it another way?
September 11, 2012 at 4:20 am
Another thing I thought I learned and found out I didn't.
Thanks, Ravi.
September 11, 2012 at 4:17 am
Okay. That makes sense.
I guess the next question is, is there any method of prediction on lock types or does it literally just come down to what the engine is...
September 10, 2012 at 11:19 am
GilaMonster (9/10/2012)
Brandie Tarvin (9/10/2012)
Is there a way to use an estimated execution plan to determine what kind of locks will be held on a table?
No. The optimiser knows nothing about...
September 10, 2012 at 10:55 am
GilaMonster (9/10/2012)
Oh, and please note that the blog post you referenced is 90% copy-paste from these two pages:http://msdn.microsoft.com/en-us/library/ms184286%28v=sql.105%29.aspx
Ah. Thank you for pointing that out.
September 10, 2012 at 10:20 am
Viewing 15 posts - 3,991 through 4,005 (of 9,712 total)