Viewing 15 posts - 6,106 through 6,120 (of 7,191 total)
Roy Ernest (2/27/2008)
I have doubt.... Since Stored Procs can have recompiles and then take bad query plans, cant view also have that same issue?
Since a view doesn't take parameters,...
February 27, 2008 at 6:57 am
Luis
Please will you post DDL for your tables in the form of CREATE TABLE statements, sample data in the form of INSERT statements, the results your query is producing, and...
February 27, 2008 at 2:39 am
JMSM
Try experimenting with the date style parameter in the CONVERT function. This may prevent the "out of range" error eppearing.
John
February 26, 2008 at 8:26 am
Sounds like something you would want your app, rather than SQL Server, to do. Put please will you post table definitions in the form of CREATE TABLE statements and...
February 26, 2008 at 7:48 am
Phil
If it's zero already then it won't matter if you update it to zero, so this will work just as well:
UPDATE [Database].[schema].[Table]
SET column_name = 0
John
February 26, 2008 at 6:42 am
Since you're doing this all in one transaction, I don't think it'll make any difference what your recovery mode is.
The first part of your clustered index key is PocketPCID and...
February 26, 2008 at 4:22 am
Karthik
If you're working in the UK, you'll be paying your umbrella company fees in pounds. As I said, you shouldn't be paying more than about £100 per month. ...
February 22, 2008 at 4:37 am
Yes, there is. Don't use your command 2, but use the exact command that Andras and I both posted above. That should work for you... in seconds.
John
February 21, 2008 at 9:58 am
It's difficult to understand what you're trying to do. Please will you post a sample of the results you're getting, and then show how they should look?
John
February 21, 2008 at 4:54 am
£480 per day is an excellent rate for a first-time contractor, so congratulations! £350 per month is a lot for an umbrella company to take, so take the time...
February 20, 2008 at 4:02 am
Alt-X? Ctrl-E? I wasn't aware of either - I use F5!
John
February 13, 2008 at 1:39 am
Please will you post DDL in the form of CREATE TABLE statements and sample data in the form of INSERT statements, together with the results you expect. How is...
January 31, 2008 at 7:20 am
But you can't divide into four filegroups anyway, since one of your tables is 39GB... unless you partition the table.
John
January 30, 2008 at 9:06 am
Yes, but you're not comparing like for like. You need to compare the code that Sergiy and I suggested against the code in your original post.
John
January 30, 2008 at 6:26 am
Viewing 15 posts - 6,106 through 6,120 (of 7,191 total)