Viewing 15 posts - 11,101 through 11,115 (of 49,566 total)
Restore from your last good backup.
November 1, 2013 at 10:02 am
Then you're going to have to use dynamic SQL.
November 1, 2013 at 9:43 am
Why drop and create a table to change a column name? Why not use sp_rename?
November 1, 2013 at 9:26 am
Consolas 10pt usually. 18-28pt if I'm presenting, depending on where.
November 1, 2013 at 8:05 am
Write latency on the log drive.
When you have the inserts as separate transactions (no user-defined transaction), each one has to flush the log to disk before it's complete. When you...
November 1, 2013 at 5:24 am
afshin.khorram (10/31/2013)
Have you guys ever used a recovery model switch? Do you recommend it?
To bulk-logged recovery for loads and index rebuilds sometimes. To from full to simple and back,...
October 31, 2013 at 10:59 pm
Run a CheckDB please?
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
October 31, 2013 at 3:27 pm
sysobjects and syscomments are deprecated (have been for 8 years), should not be used any longer.
Use sys.objects and sys.sql_modules.
October 31, 2013 at 3:09 pm
Nothing at all unusual about column stats (stats that aren't associated with indexes). The naming's a little odd though.
What do each of these return?
DROP STATISTICS ABCTable._dta_index_ABCTable_c_7_745806881__K2
DROP STATISTICS ABCTable._dta_stat_745806881_2_1
DROP INDEX _dta_index_ABCTable_c_7_745806881__K2...
October 31, 2013 at 3:07 pm
Are they stats (show up in sys.stats) or are they indexes (show up in sys.indexes)? What's the exact statement you're running and the exact error you're getting?
btw, if you drop...
October 31, 2013 at 2:27 pm
One TempDB, multiple data files. You do not have multiple TempDB databases. All databases on that instance use the one sole TempDB database.
October 31, 2013 at 2:25 pm
Are you using the trace flag to enable large pages?
October 31, 2013 at 2:11 pm
An instance can only have a single TempDB, so any database on that instance will use that single TempDB database.
October 31, 2013 at 12:34 pm
The only place I've worked at that wanted to do a credit check was the bank, and they did have a good reason. New company did background and education checks...
October 31, 2013 at 11:02 am
The logical reads you posted in the OP look quite low.
What about this query made you look at it?
October 31, 2013 at 11:00 am
Viewing 15 posts - 11,101 through 11,115 (of 49,566 total)