Viewing 15 posts - 43,831 through 43,845 (of 49,552 total)
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 8:07 am
What recovery model is the database in?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 3:40 am
Aslo asked here:
http://www.sqlservercentral.com/Forums/FindPost584664.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 3:37 am
Duplicate post Please post replies to:
http://www.sqlservercentral.com/Forums/Topic584776-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 2:59 am
Why do you need to reclaim the space? If you do, the DB is just going to grow again next time you rebuild indexes.
Is it the data or the log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 2:46 am
You don't need to do another fetch in the middle of the cursor loop. Fetch can't have a condition on it. It fetches values from a cursor row. All you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 2:45 am
amit (10/13/2008)
Hi All,I ran an index defrag on my db which was 71gb, it has now become 91 gb.. Is this normal???
Yes. SQL needs space to rebuild the index. Don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 2:27 am
Are you sure that's coming from the maintenance plan? If you start the maint plan's job manually, do you get the same error? How ofte is it scheduled, what does...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 1:35 am
Viewing 15 posts - 43,831 through 43,845 (of 49,552 total)