Viewing 15 posts - 8,686 through 8,700 (of 22,214 total)
ASPState is difficult to deal with. Generally, isolating it as much as possible is the best bet. Better bet, don't use it for state management of your ASP pages. Storing...
March 13, 2014 at 5:20 am
SQLRNNR (3/12/2014)
Lynn Pettis (3/12/2014)
SQLRNNR (3/12/2014)
Lynn Pettis (3/12/2014)
william.rees.howells (3/12/2014)
March 12, 2014 at 8:14 pm
If you're on SQL Server 2012, then the answer is the Distributed Replay tool. With that you can simulate load on the system. You'll have to build the load yourself,...
March 12, 2014 at 4:53 pm
Try modifying the system database called model to have the security settings you want as outlined above. Then, when you create a new database, what's in model is what gets...
March 12, 2014 at 4:50 pm
Well, thinking about it some more, you can turn on auditing on the blob stores where the VM files are located. Set that to verbose and see what the heck...
March 12, 2014 at 4:48 pm
No, statistics aren't modified by backups.
I've been using SQL Server on Azure in VMs a ton. I haven't seen this problem crop up before, so I'm seriously stumped on what...
March 12, 2014 at 4:46 pm
No argument, but usually, it's relatively rare to change primary keys once a system has been built. It certainly doesn't make the early design and build stages or 1.1 releases...
March 12, 2014 at 9:13 am
But a cost of 5 is so cheap that plans that shouldn't be parallel can get set up as parallel, running longer and using more resources than they should.
March 12, 2014 at 7:06 am
GilaMonster (3/12/2014)
Am I slow today, or was this a little tricky to figure out? http://www.sqlservercentral.com/Forums/Topic1550137-1292-1.aspx
No, that one was weird.
March 12, 2014 at 6:40 am
Do you have database backups? You'll need to go to those to restore your system.
March 12, 2014 at 3:28 am
Based on what you're showing, those two queries are identical. There are so few tables the optimizer is going to rearrange the order to suit itself any way. There's no...
March 12, 2014 at 3:26 am
Editing and rewriting the query tuning book for 2014 when I came across this:
Queries may be attempting to deal with data in a row-by-row fashion (or to quote Jeff Moden,...
March 11, 2014 at 5:45 pm
If the memory is available to the OS, SQL Server can also use it.
As for changing from 0 to 4, 0, the default, uses all processors available. You don't need...
March 11, 2014 at 5:27 pm
Maybe get them a copy of Craig Mullins book, Database Administration. It's an awesome overview of the job. It doesn't get into technologies directly, just responsibilities and concepts. I realize...
March 11, 2014 at 5:25 pm
First blush, no, I wouldn't say it's a "bad" design.
But, if I see varchar as a primary key, I'm assuming natural keys. There are good reasons for this from both...
March 11, 2014 at 5:22 pm
Viewing 15 posts - 8,686 through 8,700 (of 22,214 total)