Viewing 15 posts - 4,201 through 4,215 (of 22,211 total)
ThomasRushton (11/21/2016)
Grant Fritchey (11/18/2016)
November 21, 2016 at 7:03 am
tazzman (11/20/2016)
If you don't need to perform point-in-time database recovery and doesn't use mirroring or other HA-solutions you can use simple recovery model.
I would only recommend this switch after an...
November 20, 2016 at 8:37 am
Ad Hoc:
SELECT * FROM Table;
If this is run from SQL Server Management Studio, Reporting Services, Integration Services, or through code from an app, it's ad hoc because it's not in...
November 18, 2016 at 1:02 pm
For the second time this year, I successfully got a Linux VM running with SQL Server on it. Last time I just did the install & walked away. This time...
November 18, 2016 at 10:40 am
jasona.work (11/18/2016)
Grant Fritchey (11/18/2016)
jasona.work (11/18/2016)
November 18, 2016 at 8:43 am
jasona.work (11/18/2016)
November 18, 2016 at 7:22 am
Quest had a tool like that once upon a time. I think it's long been discontinued.
For testing the running of a procedure, it's not hard to write a quick PowerShell...
November 18, 2016 at 6:01 am
Two tools that I would suggest that can help with this (you're still going to have to do a lot of work to understand exactly what is being documented) are...
November 18, 2016 at 5:55 am
Yeah, you're recompiling all the plans after that runs. It might not be that big a deal. It really depends on your system, the code, all sorts of factors. Also,...
November 17, 2016 at 12:29 pm
Ed Wagner (11/17/2016)
I didn't make it through the entire presentation, but I read the announcement - thank you for...
November 17, 2016 at 7:33 am
Another third party tool to check out is Minion Ware. They have a free version of an index management software that does a fantastic job of managing your indexes.
November 17, 2016 at 4:06 am
I'm not sure then.
November 16, 2016 at 12:30 pm
I have never attempted to set up replication to Azure SQL DB. I suppose it will work since it's in the documentation. I'd strongly suggest testing it and setting it...
November 16, 2016 at 11:48 am
I strongly recommend getting a copy of Craig Mullins book: Database Administration. It covers the job, as a job. It's technology agnostic. It'll give you a more complete picture of...
November 16, 2016 at 10:01 am
Viewing 15 posts - 4,201 through 4,215 (of 22,211 total)