Viewing 15 posts - 4,696 through 4,710 (of 22,211 total)
I wouldn't try doing this through T-SQL. Instead, look to Powershell. There are tons of examples of exactly this type of on demand script generation using PowerShell.
June 1, 2016 at 3:22 am
Steve Jones - SSC Editor (5/31/2016)
New sample db: https://github.com/Microsoft/sql-server-samples/blob/jodebrui/samples/databases/wide-world-importers/documentation/root.md
And I intend to start messing with it as soon as I get the new bits installed tomorrow.
May 31, 2016 at 8:25 pm
No. All things being equal, there would be no reason why it run faster in either location. So, the question is, what's different? Are you capturing execution plans or client...
May 31, 2016 at 4:01 pm
Because SQL Fertilization needs to become something we all talk about. It's important. Don't you understand how SQL Fertilization works?
May 31, 2016 at 10:45 am
That's weird. It has to be a typo or a misinterpretation. They could mean normalization or optimization or... I've never heard of SQL Fertilization, so I've got nothing. Of course,...
May 31, 2016 at 10:40 am
TheSQLGuru (5/31/2016)
Igor Micev (5/31/2016)
My experience with SSDs on a write-intensive instance was very bad. The SSDs went out for 2 months.
What SSDs did you have? What was very bad about...
May 31, 2016 at 8:04 am
I don't think there's a single list of just the @@ values. They're used for different things in different ways and the usage seems to determine their placement within the...
May 31, 2016 at 7:14 am
I'm with Kevin. You'd be better off looking at the vendor site for whatever drive system you have. I know, for example, that PurStorage has a lot of guidance on...
May 31, 2016 at 4:48 am
Copyright on it would be 2014 I think. Mine says " - Second Edition" on the spine.
May 27, 2016 at 8:35 am
Oh, and head over to Redgate Software. We offer a ton of free e-books. There are a couple that are worth reading. Gail was an author (or tester, I forget)...
May 26, 2016 at 3:41 pm
If it makes you feel better, I don't set the price.
May 26, 2016 at 3:38 pm
The error has to say something beyond invalid. Maybe it's a backup from a newer version of SQL Server than where you're trying to restore it? There could be any...
May 26, 2016 at 10:36 am
If you hit specific questions, you can always post them here on SQL Server Central and you'll get help.
If you have specific questions about the book, don't hesitate to get...
May 26, 2016 at 8:08 am
Brandie Tarvin (5/26/2016)
May 26, 2016 at 6:38 am
Brandie Tarvin (5/25/2016)
Eirikur Eiriksson (5/25/2016)
Luis Cazares (5/25/2016)
Gazareth (5/25/2016)
jasona.work (5/25/2016)
Eirikur Eiriksson (5/25/2016)
Brandie Tarvin (5/25/2016)
Brandie Tarvin (5/25/2016)
<singing>
All the lonely servers. Where do they all come from? All the lonely servers... Where doooo...
May 25, 2016 at 1:04 pm
Viewing 15 posts - 4,696 through 4,710 (of 22,211 total)