Viewing 15 posts - 23,611 through 23,625 (of 49,552 total)
SQL Server Administration? SQL Server Development? SQL BI? Some other aspect?
There's no one book that covers everything awesomely.
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
September 10, 2011 at 1:52 am
I do performance tuning for a number of clients, have done for over 5 years. I can count on one hand the number of times I've needed a join 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
September 10, 2011 at 1:47 am
You're missing my point. We were talking nested transactions, not savepoints
No matter how many open transactions there are, a ROLLBACK TRANSACTION always rolls back to the outermost transaction. If it'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
September 10, 2011 at 1:46 am
Join hints (and just about all other hints) are for when you are absolutely, completely, 100% sure you know better than the query optimiser, and you know why the optimiser...
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
September 9, 2011 at 4:01 pm
Grant Fritchey (9/9/2011)
Besides, I like cats. I just can't eat a whole one by myself.
Cats: You can't live with 'em, and there's not enough fur for a rug.
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
September 9, 2011 at 3:57 pm
Converting MySQL code to SQL Server code is far from a trivial exercise. You'll probably need to near-rewrite the whole thing.
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
September 9, 2011 at 1:43 pm
Want to be really evil? (now we are getting into the mess that is nested transactions, named transactions and error handling)
How many rows does that select return? 0, 1, 2...
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
September 9, 2011 at 1:37 pm
Ninja's_RGR'us (9/9/2011)
GilaMonster (9/9/2011)
The only one that fails is a rollback that references a name that doesn't exist, and that's a side-effect of savepoints.
So yay / nay on the qotd. ...
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
September 9, 2011 at 11:58 am
No pre-sizing. SQL creates and manages those files, you should not touch them in any way.
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
September 9, 2011 at 11:53 am
The only one that fails is a rollback that references a name that doesn't exist, and that's a side-effect of savepoints.
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
September 9, 2011 at 11:47 am
Hassle2 (9/9/2011)
And the users with sysadmin were able to work. I had noted that bit wrong on my paperwork.
Because sysadmins are by definition given every permission in 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
September 9, 2011 at 11:46 am
p.s. All of these are valid
BEGIN TRANSACTION SomeTran
INSERT INTO dbo.TestingCleanup (Description)
VALUES ('Hi')
ROLLBACK TRANSACTION
BEGIN TRANSACTION SomeTran
INSERT INTO dbo.TestingCleanup (Description)
VALUES ('Hi')
ROLLBACK TRANSACTION SomeTran
BEGIN TRANSACTION
INSERT INTO dbo.TestingCleanup (Description)
VALUES ('Hi')
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
September 9, 2011 at 11:42 am
Ninja's_RGR'us (9/9/2011)
Any reason why Begin tran <name>doesn't require rollback tran <name> for the undo?
Because a transaction's name is purely and only for documentation purposes and serves no syntactical purpose.
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
September 9, 2011 at 11:39 am
That's what a spool is. Put x rows into a temporary structure and read them multiple times. What you're probably seeing is the 21 million is a cumulative count over...
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
September 9, 2011 at 10:32 am
PaulB-TheOneAndOnly (9/9/2011)
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
September 9, 2011 at 10:06 am
Viewing 15 posts - 23,611 through 23,625 (of 49,552 total)