Viewing 15 posts - 4,006 through 4,020 (of 9,722 total)
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
It would be easier for us to answer that question if you posted the requested DDL and sample data. The sample data doesn't have to be real. You can fake...
September 10, 2012 at 9:08 am
Stewart "Arturius" Campbell (9/10/2012)
The issue relates to the
and dateadd(day, -30, getdate())section of the where clause.
And apparently I don't remember how to read this morning. DUH.
Good catch.
September 10, 2012 at 8:31 am
Post your table DLL, an INSERT statement with sample data, and what you've written on the CTE. That will help us help you better.
September 10, 2012 at 8:31 am
I think I have found my issue. Details in this post: http://www.sqlservercentral.com/Forums/Topic1356750-391-1.aspx?Update=1
September 10, 2012 at 8:24 am
Anyone can answer if they still wish to, but I think I found my issue.
Estimated Plan pointed out some index seeks. I googled locks and indexes and stumbled across the...
September 10, 2012 at 8:23 am
Viewing 15 posts - 4,006 through 4,020 (of 9,722 total)