Viewing 15 posts - 7,471 through 7,485 (of 7,597 total)
On the really large tables, looks like you are using LID, varchar(100), to join / match on them.
Is there an index on LID on the large tables? If so,...
January 11, 2012 at 2:39 pm
Running SELECT * FROM test.dbo.sysfiles I got the following
To be safe, you really should run against test.sys.database_files, since that is what SQL is actually looking at ... notice...
January 10, 2012 at 2:48 pm
Given that this is SQL 2008 (or SQL 2005 at least), you mean:
SELECT *
FROM test.sys.database_files
right? 🙂
January 10, 2012 at 2:22 pm
Ok.
See what is in the sys.master_files "table" for that db:
SELECT *
FROM sys.master_files
WHERE
database_id = DB_ID(N'test')
January 10, 2012 at 2:19 pm
Once the SQL Agent logs have scrolled off -- that is, been renamed as SQLAGENT.1, ~.2, etc., by SQL Server -- you can just go into Windows and delete them....
January 10, 2012 at 1:58 pm
Verify the logical file names are what you expect them to be.
USE <your_db_name>
EXEC sp_helpfile
--Or: EXEC <your_db_name>.dbo.sp_helpfile
The first column will show the logical file name, which, of course, must match what...
January 10, 2012 at 1:54 pm
The need for the end user to define columns (not fields) might just be the most obvious evidence of a bad design....
Do you have an example where such a...
January 10, 2012 at 1:51 pm
That physical file copy thing's not looking so bad now, is it? :-):-)
January 3, 2012 at 2:56 pm
SQL 2005 is different from either.
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx
1. Insert the SQL Server 2005 installation media into the disk drive.
2. Use the following syntax:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1...
January 3, 2012 at 2:55 pm
Excellent point.
For SQL 2008, you must do run:
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=instance_name
/SQLSYSADMINACCOUNTS= accounts [/SAPWD=password]
If in Mixed mode, specify the /SAPWD; if Windows/Authenticated only, leave it off.
Have to admit I...
January 3, 2012 at 2:52 pm
First, make a copy of the existing master data file(s) and log file (in Windows, not a SQL BACKUP). You may be able to read some data out of...
January 3, 2012 at 2:31 pm
I've read the whole thread. Very interesting discussion.
But I don't understand the claim that "Optimistic Locking" has no overhead.
What about all those rollback/undo errors in Oracle? Oh those...
January 3, 2012 at 2:05 pm
Interesting. TRUNCATE doesn't fire triggers, so I wouldn't think a trigger would be causing the partial DELETEs.
Is this the actual table that is being TRUNCATEd, or somehow is it...
December 5, 2011 at 7:45 am
FROM master.sys.syslogins a
INNER JOIN SPUTIL.sys.sysusers b
Why do you keep referring back to the "ancient" SQL 2000 views?
MS itself tells you they're not reliable for SQL 2005 and SQL 2008.
December 2, 2011 at 12:14 pm
Viewing 15 posts - 7,471 through 7,485 (of 7,597 total)