Viewing 15 posts - 106 through 120 (of 646 total)
For me partitioning is about manageability first and performance second.
Your MDF is 500MB with 8 years growth? I'm not so sure you need to go down this route... don't...
August 24, 2016 at 3:58 am
jasona.work (8/23/2016)
Beatrix Kiddo (8/23/2016)
ACT CALM. They need to think you are calm :-P.
This, a thousand times this...
When I was still in a sysadmin role and the senior guy in the...
August 23, 2016 at 8:35 am
erico (8/22/2016)
Is there direct upgrade path from SQL server 2008 to SQL Server 2016? What about earlier versions?
You can backup+restore (safest way) or detach+attach (not a safe way) from SQL...
August 23, 2016 at 4:17 am
Yes SSIS is possible for both azure SQL DB and DWH
August 22, 2016 at 12:18 pm
Ed Wagner (8/19/2016)
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Congratulations, Gail. Now if...
August 22, 2016 at 7:47 am
Ok how about PowerShell to create Azure SQL DBs? Rather than portal based stuff?
August 19, 2016 at 3:31 am
SQLRNNR (8/18/2016)
BLOB_EATER (8/18/2016)
jasona.work (8/17/2016)
Forums being moved to a new back-end, cheap beer pubs with...
August 19, 2016 at 12:49 am
Grant Fritchey (8/18/2016)
Jeff Moden (8/18/2016)
It also names the stats in a fashion almost identical to how SQL Server does it
BWA-HA-HA!
I was just having a conversation about statistics in India...
August 18, 2016 at 8:48 am
jasona.work (8/17/2016)
Forums being moved to a new back-end, cheap beer pubs with hair in...
August 18, 2016 at 12:46 am
Have a look at the installer logs (if any) %programfiles%\MicrosoftSQL Server\120\Setup Bootstrap\Log
August 17, 2016 at 8:09 am
August 17, 2016 at 7:55 am
ChrisM@Work (8/17/2016)
tindog (8/17/2016)
ChrisM@Work (8/17/2016)
Luis Cazares (8/17/2016)
Brandie Tarvin (8/17/2016)
Eirikur Eiriksson (8/17/2016)
BrainDonor (8/17/2016)
ChrisM@Work (8/17/2016)
We have git hubs all over the UK. They're also known as Weatherspoons.You owe me a new keyboard...
😀
...just managed...
August 17, 2016 at 7:37 am
ChrisM@Work (8/17/2016)
We have git hubs all over the UK. They're also known as Weatherspoons.
I'm going there right now.
August 17, 2016 at 3:14 am
Jeff Moden (8/16/2016)
BLOB_EATER (8/16/2016)
Jeff Moden (8/16/2016)
BLOB_EATER (8/16/2016)
August 16, 2016 at 8:48 am
I hardly ever shrink data files. I Rather leave the space there for future growth.
August 16, 2016 at 8:37 am
Viewing 15 posts - 106 through 120 (of 646 total)