Viewing 15 posts - 12,691 through 12,705 (of 49,552 total)
The first creates a primary key, the second creates a unique clustered index. They're two different structures. Mostly SQL uses them in a similar way, but there are places 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
June 19, 2013 at 12:52 am
T.Ashish (6/18/2013)
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
June 19, 2013 at 12:43 am
Please tell me I'm reading that last post from the OP wrong.
http://www.sqlservercentral.com/Forums/Topic1464172-391-1.aspx
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
June 19, 2013 at 12:40 am
Sai Viswanath (6/18/2013)
reason am not getting a chance to view them while generating the report.
Profiler, Extended events, plan cache. Many ways to get the queries without needing to see 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
June 19, 2013 at 12:38 am
Please post table definitions, index definitions and execution plan.
You can start by removing the nolock hints, not because removing them will improve performance, but because removing them will remove 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
June 18, 2013 at 1:14 pm
aiki4ever-796329 (6/18/2013)
Thanks for the help! Bouncing the SQL Server was enough to make the database operational.
I seem to recall saying not to do that. Often in this kind...
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
June 18, 2013 at 1:07 pm
As I said, setting offline is completely the wrong solution. DO NOT try to take the DB offline, detach it or to restart SQL server.
What other messages are there in...
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
June 18, 2013 at 12:27 pm
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1464819-392-1.aspx
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
June 18, 2013 at 12:04 pm
😀
Typically the cause for something like this is non-space whitespace characters. There are a few ascii characters that don't show, but aren't spaces. CR and LF are two that immediately...
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
June 18, 2013 at 11:35 am
Either the database was switched to simple recovery or the log was truncated explicitly (which isn't possible on SQL 2008) or the database was reverted to a snapshot. That's about...
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
June 18, 2013 at 11:26 am
And the exact error you're getting is???
p.s. truncating the log is the incorrect approach. Shrinking the log is the incorrect approach. Setting the database offline is the incorrect approach and...
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
June 18, 2013 at 11:17 am
Details of recovery models:
http://www.sqlservercentral.com/articles/Administration/75461/
http://www.sqlservercentral.com/articles/Recovery+Model/89664/
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
June 18, 2013 at 11:10 am
Someone's run a switch to simple recovery and back to full since the last full/diff backup. It'll be logged in the error log.
p.s. Are you sure you want those DBs...
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
June 18, 2013 at 11:10 am
LTRIM and RTRIM remove spaces. If they're not removing your non-printable characters, then they're not spaced. Identify what they are (use the ASCII command) and then use REPLACE or LEFT...
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
June 18, 2013 at 10:47 am
marks_262 (6/18/2013)
If it is not possible to restore to multiple files, is it possible to automate moving the data to multiple ndf files after the restore?
Depends what you want to...
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
June 18, 2013 at 10:45 am
Viewing 15 posts - 12,691 through 12,705 (of 49,552 total)