Viewing 15 posts - 15,946 through 15,960 (of 49,552 total)
Not a bug. Expected and documented behaviour.
The scope for column resolution within a subquery is first to the tables inside the subquery, then to the tables outside the subquery. If...
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 24, 2012 at 10:45 am
Never mind.. not up for an argument...
Just note that by adding a unique constraint, you've added a nonclustered index, unless you made it unique clustered.
While the rows on page may...
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 24, 2012 at 10:27 am
Well I certainly don't qualify. Good thing I'm not looking to change jobs....
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 24, 2012 at 10:25 am
Books Online is sufficient. It's not the easiest way, but it does cover everything.
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 24, 2012 at 7:44 am
Have a look at the list of skills measured on the MS site.
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
October 24, 2012 at 1:28 am
There's no easy way to read the tran log. You can use fn_dblog or you can buy a log reader (~$1000). Note for either to be useful the transaction 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
October 24, 2012 at 1:18 am
KILL <user's session ID>
USE <database in single user mode>
or set it to restricted user first, then single user once all the non-admins are out.
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 23, 2012 at 11:08 am
A full drive shouldn't cause SQL to crash. It'll cause transactions to fail, that's about all.
Check the SQL error log, see what's the last few entries in the log
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 23, 2012 at 9:15 am
No, simple recovery does not in and of itself cause the log to grow.
Log growth is possible in any recovery model if the largest transaction (in simple recovery) or...
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 23, 2012 at 9:07 am
Ratheesh.K.Nair (10/23/2012)
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 23, 2012 at 5:03 am
On SQL 2008, use the sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities. These track dependencies accurately, so you don't have to try and match to the object's definition. That said they show all dependencies,...
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 23, 2012 at 4:41 am
What you're querying there is not a history of queries executed, it's the plan cache which contains some info on execution history. Plans that aren't cached don't appear in there,...
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 23, 2012 at 3:21 am
Please note: 2 year old (resolved) thread
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 23, 2012 at 2:56 am
n00bDBA (10/23/2012)
Interesting, so when using dynamic sql you never put in GO? How is it ran then if you cant use GO to separate statements?
Each piece you EXEC is a...
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 23, 2012 at 2:54 am
Oh it's better. Better in the sense that it'll take me 10 seconds to reverse not 5 and require sysadmin access.
It is not encryption, it is not going to protect...
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 23, 2012 at 2:34 am
Viewing 15 posts - 15,946 through 15,960 (of 49,552 total)