Viewing 15 posts - 43,846 through 43,860 (of 49,571 total)
Splitting data into multiple files doesn't usually give much or any of a performance benefit, unless you're having IO performance issues. Are you encountering IO bottlenecks? Splitting into multiple files...
October 13, 2008 at 8:38 am
You can set the main plan to log all errors to a text file. In SQL 2005 and 2008 that's done by selecting the 'Reporting and Logging' button from the...
October 13, 2008 at 8:24 am
The best thing to do with deadlocks is find the cause and fix it. Typically deadlocks are caused by bad code, bad indexing or both.
Set traceflag 1204 on and SQL...
October 13, 2008 at 8:23 am
To alter a database there must be no connections to the DB, sleeping or otherwise. You can either kill the connections or you can use the rollback immediate option on...
October 13, 2008 at 8:18 am
I'm going to assume, since you installed only the SQL client, that the SQL database engine is installed on another server.
Are you an administrator of that server? If not,...
October 13, 2008 at 8:16 am
You can't do a shink file with empty on the primary file.
Are you looking to create multiple filegroups (in which case it's easy to move objects and the tables will...
October 13, 2008 at 8:13 am
DBA (10/13/2008)
Select @DistID_FK = (Select DistID_FK from Inserted),
@CodeID_FK = (Select CodeID_FK from Inserted),
@DateInserted= (Select DateInserted from Inserted)
What's going to happen here is the insert affects more than one row?...
October 13, 2008 at 8:07 am
What recovery model is the database in?
October 13, 2008 at 8:01 am
rgillings (10/13/2008)
I wouldn't feel right if I didn't offer a non-cursor alternative.
A while loop is little if at all better than a cursor. It's a cursor in all but name.
October 13, 2008 at 7:59 am
It's a serious error. You may not be encountering errors now, but of someone tries to use the corrupt table, they will get errors. Since it's sysdepends, that may happen...
October 13, 2008 at 3:40 am
Duplicate post Please post replies to:
http://www.sqlservercentral.com/Forums/Topic584776-146-1.aspx
October 13, 2008 at 3:34 am
Create table Products (
tempid int identity,
F2 varchar(10)
)
INSERT INTO Products (F2) VALUES ('Car1')
INSERT INTO Products (F2) VALUES (NULL)
INSERT INTO Products (F2) VALUES (NULL)
INSERT INTO Products (F2) VALUES (NULL)
INSERT INTO Products (F2)...
October 13, 2008 at 3:21 am
Yes, your previous code, if you ran it would have done that, as your update statement was
UPDATE dbo.Products SET F2 = @ColumnE WHERE F2 IS NULL
If you ran that at...
October 13, 2008 at 3:13 am
Please run the following and see what you get.
SELECT getdate()
EXEC master..xp_cmdshell 'DATE /T'
EXEC master..xp_cmdshell 'TIME /T'
October 13, 2008 at 2:59 am
Viewing 15 posts - 43,846 through 43,860 (of 49,571 total)