Viewing 15 posts - 9,031 through 9,045 (of 19,560 total)
Toreador (8/17/2011)
mbova407 (8/17/2011)
TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions.Emphasis mine 😉
When truncating - Row actions are not logged. Page deallocations (which...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2011 at 9:47 am
Subjective Adapts (8/17/2011)
TruncateDelete
Faster in performance wise, because it doesn’t keep any logs
Slower than truncate because, it keeps logs
Rollback is not possible
Rollback is possible
Actually Truncate is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2011 at 9:38 am
Basics type of question.
Still astounds me that sooooo many people believe that truncate is not logged. At the time I answered, 44% of respondents selected that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2011 at 9:34 am
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2011 at 9:25 am
I have seen it many times more often in a CTE than the older Derived table. I think this syntax has some usefulness when thinking through it. I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2011 at 9:12 am
bc_ (8/17/2011)
I don't know if this would always work, but this at least works for the given puzzle to return it in 9 x 9:
SELECT TOP 9...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2011 at 9:07 am
It is actually very similar to the construct for a cte. A CTE is in essence the new way of doing a derived table.
Break down the query like this
SELECT...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 9:40 pm
Lynn Pettis (8/16/2011)
Sneak peek didn't work, at least for me.
Crud - I had hoped it would since it worked for me. It is scheduled to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 6:15 pm
It is not a common syntax, but it is listing the column names for the virtual table created by that subquery.
Here is syntax that is easier to read.
DECLARE @studentID INT...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 5:53 pm
That is a fast and easy enough way to do it.
I would suggest creating a domain group and adding users to that domain group. Then add the domain group...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 5:41 pm
Interesting. Mine displays the links between tables for those that already have FKs defined.
I'd look at doing this through a different tool. You may not want to make...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 5:38 pm
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 5:34 pm
Late - but maybe still worth it. I'll be posting a blog on it shortly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 4:43 pm
It generally creates those links if the keys already exist.
Do you already have FKs defined?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 4:24 pm
I would ensure the RBS filegroup for each content database had a different name. I would also test it heavily in a dev/qa environment and ensure it works. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 3:40 pm
Viewing 15 posts - 9,031 through 9,045 (of 19,560 total)