Viewing 15 posts - 41,836 through 41,850 (of 49,562 total)
Gautam Saha (1/9/2009)
January 10, 2009 at 1:48 am
It's parallelism. It's something that SQL decides to do, not the developer.
Not all of the threads will likely be running and there can be more than the maxdop set or...
January 10, 2009 at 1:02 am
If all the queries that filter on the quid are equalities (hence finding 1 row), I'd put a nonclustered index on the Guid and find somewhere else for the cluster.
I've...
January 10, 2009 at 12:48 am
Digs (1/9/2009)
SO are you saying the code in asp.net codebehind and TSQL 2005 stored proceedures can be hacked ...?????
Anyone that has login rights to the SQL Server and either execute...
January 10, 2009 at 12:45 am
No way to tell.
I'm asking what appears to cause it, not the root cause. What are you generally doing when it happens?
Earlier advice still applies. The best people to contact...
January 10, 2009 at 12:35 am
Gautam Saha (1/9/2009)
Can I break up the database so that it consists of 4 mdf/ndf files
You can. What are you trying to achieve by doing so?
January 9, 2009 at 2:54 pm
Tim Riley (1/9/2009)
January 9, 2009 at 2:19 pm
What are the security settings of the linked server?
Are you sure the linked server is pointing at the correct database on the remote server?
January 9, 2009 at 1:55 pm
Lynn Pettis (1/9/2009)
GilaMonster (1/9/2009)
It's do-it-yourself sample data. Values at the top of the post, insert statements at the bottom. 😛 😀
That I think not. Too many data columns for...
January 9, 2009 at 1:53 pm
Lynn Pettis (1/9/2009)
hmmmm, something missing I am. No data I see in the insert statements.
It's do-it-yourself sample data. Values at the top of the post, insert statements at the...
January 9, 2009 at 1:45 pm
This has nothing to do with Kerberos. The error is saying that either the table that you're querying does not exist, or the user that you're connecting across the linked...
January 9, 2009 at 1:44 pm
Great, we've got table structure and sample data.
Based on the sample data you have posted, what are the exact results that you want? Post exactly what values you need the...
January 9, 2009 at 1:29 pm
Tim Riley (1/9/2009)
January 9, 2009 at 1:22 pm
Grant Fritchey (1/9/2009)
GilaMonster (1/9/2009)
January 9, 2009 at 1:14 pm
DavidB (1/9/2009)
January 9, 2009 at 1:12 pm
Viewing 15 posts - 41,836 through 41,850 (of 49,562 total)