Viewing 15 posts - 43,561 through 43,575 (of 49,571 total)
patricklambin (10/27/2008)
( maybe with new features coming from the 2008 version, i can dream)
If they did that, what incentive would you have to get SQL 2008?
October 27, 2008 at 2:22 am
What were the full results of the CheckDB that listed the errors?
October 27, 2008 at 2:19 am
Is it still happening?
What login are the maintenance plans running as? What rights does that login have?
October 27, 2008 at 2:18 am
IsNumeric returns true if the value passed to it can be successfully converted into any one of the numeric datatypes.
3D2 and 3E2 can be cast to float (and mean 300),...
October 27, 2008 at 2:17 am
Please post table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached)
How many rows are in the tables? How long does the query run for?...
October 27, 2008 at 1:33 am
r.dragoi (10/23/2008)
Can you do a test changing the isolation level ?I would change it to read uncommitted , in your case is read committed.
Isolation levels only...
October 27, 2008 at 1:26 am
You can script the indexes and just apply them on the other server. Import/export just moves the data
Go to object explorer in management studio, expand out until you see the...
October 27, 2008 at 1:17 am
nairsanthu1977 (10/27/2008)
Dear All,Sometimes my database goes very slow. I would like to finetune the database.
Can anyone suggest wot are the things to be done please.?
That's a very open question.
Make sure...
October 27, 2008 at 1:16 am
nairsanthu1977 (10/27/2008)
For time being whot I have done is, I EXPORTed all the tables from EMERGENCY databse to another temporary database. Also I copied all the SPs. So now data...
October 27, 2008 at 1:12 am
Profiler records events that occur on the server. The events range from SQL queries executed to locks acquired, to logins/logouts, to deprecations, deadlock and a whole lot more.
Performance dashboard is...
October 27, 2008 at 12:50 am
If you're trying to move the DB, detach it. If you do it through management studio, you can specify to drop all connections first. Then you can move the files...
October 27, 2008 at 12:42 am
What error did the initial detach give? (error code's fine. I can use that to get the english version)
What error did the attach_single_file give?
Do you still have the mdf and...
October 27, 2008 at 12:41 am
Stephanie J Brown (10/26/2008)
October 26, 2008 at 10:04 am
Are you looking for a way to automatically get the names and paths of the images that are in the file system into the table? Will it be a once-off...
October 26, 2008 at 5:09 am
Two options. Have a column in the table that stored the full path and filename, or you can put the entire picture in the table using a varbinary(max) column
If that...
October 26, 2008 at 4:16 am
Viewing 15 posts - 43,561 through 43,575 (of 49,571 total)