Viewing 15 posts - 9,571 through 9,585 (of 49,552 total)
Grant Fritchey (3/21/2014)
Didn't we already have this exact conversation earlier?
Indeed. Apparently all the previous answers were unacceptable, so keep asking until the desired answer materialises.
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
March 22, 2014 at 9:45 am
Default trace won't show much. Objects created and dropped, little else.
Search this site, there are a few articles on the subject.
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
March 22, 2014 at 9:43 am
Read the raw log backups. Not trivial, not easy, no documentation available and probably several hours at best. To be honest, not something I'd even do unless someone was insisting...
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
March 22, 2014 at 8:22 am
Restore from 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
March 22, 2014 at 8:17 am
There are more columns in the SELECT list (a lot more) than are listed in the CTE's definition. They have to be the same. Either add the rest of the...
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
March 22, 2014 at 8:15 am
Hard to say without investigation, but I'd guess that someone opened a transaction sometime between the log backup that was small and the one that was large and didn't commit...
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
March 22, 2014 at 8:13 am
Nope, no caches of old object definitions.
Not following what's happening, so can't tell you what's wrong.
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
March 22, 2014 at 8:11 am
This is the problematic query taken to basics:
SELECT col1, col1 FROM SomeTable ORDER BY col1
It's the order by, it doesn't know which col1 to sort by. Wasn't caught by the...
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
March 21, 2014 at 4:09 pm
If the snapshot tool is capable of hooking into SQL and quiescing the IOs, the approach will work. It could that on windows 2008 it was doing that and now...
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
March 21, 2014 at 4:07 pm
EXECUTE <procedure name> WITH RECOMPILE will generate a new plan just for this execution, the generated plan won't be cached and the cached plan won't be affected.
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
March 21, 2014 at 9:56 am
Providing you don't have replication or CDC. It's not the best option though.
Take backups first. Test in dev/test first.
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
March 21, 2014 at 9:54 am
Sushant Yadav (3/21/2014)
1)5)
DBCC CHECKDB (database_name, REPAIR_ALLOW_DATA_LOSS)
Please check for error and use appropriate option.
Don't do this. Whatever else you do, do not follow this advice. Repairing with no idea what's...
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
March 21, 2014 at 9:54 am
Grant Fritchey (3/20/2014)
Try deleting the log file and attaching the database without the log. It might not work, but it's worth a shot.
It won't work. Deleting the log requires...
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
March 21, 2014 at 4:18 am
When you set implicit transactions on, any statement starts a transaction which is not committed until you explicitly commit it. It's something you only use if you know what you're...
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
March 21, 2014 at 4:14 am
Use the data type which is appropriate to the values you are storing.
If you're storing integer values, use integers. End of story.
Don't make non-standard design decisions based on performance...
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
March 21, 2014 at 4:11 am
Viewing 15 posts - 9,571 through 9,585 (of 49,552 total)