Viewing 15 posts - 11,101 through 11,115 (of 49,552 total)
Restore from your last good backup.
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
November 1, 2013 at 10:02 am
Then you're going to have to use dynamic SQL.
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
November 1, 2013 at 9:43 am
Why drop and create a table to change a column name? Why not use sp_rename?
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
November 1, 2013 at 9:26 am
Consolas 10pt usually. 18-28pt if I'm presenting, depending on where.
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
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...
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
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,...
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 31, 2013 at 10:59 pm
Run a CheckDB please?
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 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.
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 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...
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 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...
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 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.
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 31, 2013 at 2:25 pm
Are you using the trace flag to enable large pages?
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 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.
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 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...
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 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?
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 31, 2013 at 11:00 am
Viewing 15 posts - 11,101 through 11,115 (of 49,552 total)