Viewing 15 posts - 25,216 through 25,230 (of 49,552 total)
SQLkiwi (7/3/2011)
If I go to the Summit, I'm looking at around NS$6000 out of my own pocket just for the travel side.
A little under $2000 USD here (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
July 4, 2011 at 1:10 am
Fal (7/3/2011)
Jim Murphy (7/1/2011)
Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!
Congrats Gail!
But, er, "again"? Does this mean you are now twice the MVP you were...
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
July 4, 2011 at 1:07 am
The problem is that the explanation is not clear enough to be able to say definitively that X happened, from the sound of things no one really does know clearly...
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
July 3, 2011 at 5:47 pm
If the commit was reached then the transaction is durable and the effects are persistant. Sure there's absolutely no way that the transaction may not have committed (nested transaction you...
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
July 3, 2011 at 5:23 pm
jasonwi1202 (7/3/2011)
Just to rule out that your query isn't taking a long time to run due to it displaying a ton of rows in the output window, can you...
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
July 3, 2011 at 5:02 pm
Did the transaction commit? A session can be sleeping (awaiting command) with an open transaction. If the transaction doesn't commit, SQL will roll it back on restart, disconnect or restore.
You...
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
July 3, 2011 at 4:57 pm
So why aren't you coming to Summit?
Believe me, I'm going to be working for my comp'd conference attendance (and so's Grant). Not all sunshine and roses...
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
July 3, 2011 at 3:57 pm
Make sure there's enough space available. There's no way to build an index when you don't have enough space to put it.
You can use Sort in TempDB to move 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
July 3, 2011 at 1:39 pm
Yup. MVPs get a massive discount straight off and we get a whole bunch of opportunities to help out with various of the summit events to get a complete conference...
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
July 3, 2011 at 11:17 am
To be honest, if you insist on selecting all rows then you must just accept that it takes time. It takes time to get that volume of data off disk....
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
July 3, 2011 at 11:12 am
To create an index you will need easily 120% of the size of the index. Since your table is 514GB and you asked for 90% fill factor that means you'll...
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
July 3, 2011 at 9:28 am
Volunteer for what?
What Paul mentions is MVP-specific stuff that come straight to us (eg spending time in the 'ask the experts', hosting a 'birds of a feather' lunch table,...
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
July 3, 2011 at 9:25 am
You need to point the filestream directory somewhere too (and ensure that filestream is enabled)
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
July 3, 2011 at 3:37 am
Joy Smith San (7/2/2011)
1. What happens to SQL Server when we shut down/Start Windows..?
It stops and restarts. Nothing fancier than that.
Sometimes SQL server takes hell lot of time after starting...
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
July 3, 2011 at 3:35 am
Shamshad Ali (7/2/2011)
select COUNT(*) FROM UserProfile -- 173958
I am running following simple query which is taking min. of 26 seconds and max. (i...
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
July 2, 2011 at 10:45 am
Viewing 15 posts - 25,216 through 25,230 (of 49,552 total)