Viewing 15 posts - 5,146 through 5,160 (of 22,211 total)
GilaMonster (1/28/2016)
Alan.B (1/28/2016)
What I hate about Azure SQL & Azure SQL Data Warehouse is the limitations, specifically the T-SQL limitations.
Which ones?
I ask because, for the Azure SQLDB side, most...
January 29, 2016 at 9:58 am
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Yeah, I'd love to teach...
January 29, 2016 at 9:54 am
Sounds great. Can't wait to sit through it.
January 29, 2016 at 9:51 am
With that in mind, the one piece of advice I would offer is that everyone needs to approach their choice of data storage more carefully. Too many people are either...
January 29, 2016 at 9:50 am
WayneS (1/28/2016)
Grant Fritchey (1/28/2016)
Steve Jones - SSC Editor (1/28/2016)
Plus Grant seems to avoid...
January 28, 2016 at 10:39 am
Welsh Corgi (1/28/2016)
Grant Fritchey (1/28/2016)
January 28, 2016 at 10:36 am
Steve Jones - SSC Editor (1/28/2016)
Plus Grant seems to avoid writing on it...
January 28, 2016 at 9:07 am
That is a giant topic. I really like the rankings that you've seen linked.
What are you looking for?
January 28, 2016 at 8:26 am
The way I've dealt with this in the past is to use T-SQL or PowerShell to generate the scripts. Script the scripts. That way you don't have to rely on...
January 28, 2016 at 8:14 am
Yep. That's how you do it with the GUI. The potential issue there is that you could have out-of-stream backups of different types that the GUI might not always deal...
January 28, 2016 at 7:21 am
To get data moving both directions you're probably looking at Merge Replication. But that requires quite a bit of redesign. You could use transactional replication, but it's a one way...
January 28, 2016 at 5:15 am
Great topic. I'd add one more sentence to the abstract. It feels short. I'd add two or three specific techniques that you're going to teach so that people know what...
January 28, 2016 at 5:12 am
There are differences in the estimates. That's going to lead to differences in the plans. So, I'd focus on the statistics. Open them up and see if they're different. If...
January 27, 2016 at 8:42 am
Unless you set a limit on the amount of memory you're going to allocate to SQL Server, it will always use all the memory. That's how it works.
January 27, 2016 at 8:34 am
The question you're asking is also largely going to be determined by things other than SQL Server. What kind of disks and controllers are we talking about? How much memory...
January 27, 2016 at 8:31 am
Viewing 15 posts - 5,146 through 5,160 (of 22,211 total)