Viewing 15 posts - 37,891 through 37,905 (of 49,571 total)
paulneyman (7/5/2009)
I see your point, but the code I wrote is not a real DB structure.You solution does not suit.
Would it be possible for you to show us the real...
July 5, 2009 at 11:24 am
The backup in question has been striped across two files, with half the backup in each one. This commonly happens by accident when backing up through management studio. If there...
July 5, 2009 at 10:03 am
July 5, 2009 at 10:01 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic747333-338-1.aspx
July 5, 2009 at 6:09 am
Gift Peddie (7/5/2009)
July 5, 2009 at 5:52 am
That shouldn't be enough to deadlock.
Can you switch traceflag 1222 on, instead of 1204. Post the result of that graph here.
DBCC TRACEON(1222,-1)
July 5, 2009 at 5:29 am
Gift Peddie (7/4/2009)
July 5, 2009 at 5:12 am
The files will be retained until SQL's garbage collector runs. The files are eligible for garbage collection once they are no longer needed for database recovery. If you're in simple...
July 4, 2009 at 2:04 pm
Are both servers running the same version of SQL?
What version are they running? This looks like a SQL 2000 script.
The create table runs without error on my SQL 2008 server....
July 4, 2009 at 2:00 pm
There is no connection limitation on SQL developer edition. It is exactly like Enterprise edition in every way, except it is not licensed for production usage. The licensing on developer...
July 4, 2009 at 11:41 am
Which information in particular to you want a reference to confirm against?
July 4, 2009 at 11:38 am
Please run this and post the results
select t.name, i.type_desc, i.name, ds.name
from sys.tables t
inner join sys.indexes i on t.object_id = i.object_id
inner join sys.data_spaces ds on i.data_space_id = ds.data_space_id
July 4, 2009 at 11:35 am
waleed_m_M (7/4/2009)
but temp tables have problems in performance since they make locking for the server when it's under construction .
That was a problem on SQL 2000, when there was...
July 4, 2009 at 11:30 am
Do you have nonclustered indexes on that table? If so, they may be in different filegroups to the base table
Add i.name and i.indid to the query.
July 4, 2009 at 2:03 am
Asked and mostly answered: http://www.sqlservercentral.com/Forums/Topic745243-147-1.aspx
July 4, 2009 at 1:59 am
Viewing 15 posts - 37,891 through 37,905 (of 49,571 total)