Viewing 15 posts - 6,121 through 6,135 (of 9,399 total)
djj (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Ed Wagner (5/1/2015)
UpDirection
Location
GPS
May 1, 2015 at 6:49 am
eccentricDBA (4/30/2015)
Ed Wagner (4/30/2015)
Revenant (4/30/2015)
crookj (4/30/2015)
Ed Wagner (4/30/2015)
SQLRNNR (4/29/2015)
Revenant (4/29/2015)
Ed Wagner (4/29/2015)
Eirikur Eiriksson (4/29/2015)
Stuart Davies (4/29/2015)
Eirikur Eiriksson (4/28/2015)
Ed Wagner (4/28/2015)
TomThomson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
hall
fame
Fortune
Teller
Automatic
Tommy
Gun
Smoke
Mirrors
Reflect
surface
Pro 4
Amateur
Slapdash
Irresponsible
Management
Risk
Dice
April 30, 2015 at 1:03 pm
Hi and welcome to the forums.
While I've never tried to connect to SQL 2012 using SSMS 2005, it makes sense that it wouldn't work fully. I would upgrade to...
April 30, 2015 at 12:11 pm
If your file is on a network drive, the SQL Agent user needs permission to that network location. If you tell your network administrator the user you need, they'll...
April 30, 2015 at 12:07 pm
Alan.B (4/30/2015)
Ben-Gan's talks about this concept and provides many more examples in his book, Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
If you don't have this book, I'd highly...
April 30, 2015 at 9:43 am
Revenant (4/30/2015)
crookj (4/30/2015)
Ed Wagner (4/30/2015)
SQLRNNR (4/29/2015)
Revenant (4/29/2015)
Ed Wagner (4/29/2015)
Eirikur Eiriksson (4/29/2015)
Stuart Davies (4/29/2015)
Eirikur Eiriksson (4/28/2015)
Ed Wagner (4/28/2015)
TomThomson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
hall
fame
Fortune
Teller
Automatic
Tommy
Gun
Smoke
Mirrors
Reflect
surface
Pro 4
Amateur
Slapdash
Irresponsible
Management
April 30, 2015 at 9:36 am
When you shrink the database, it fragments your indexes very effectively. Other than having an initial size that was way off, why would you want to shrink it?
April 30, 2015 at 7:12 am
TheSQLGuru (4/30/2015)
This is coming from the Database Manager at our new company.
That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these ridiculous requirements, not some...
April 30, 2015 at 6:51 am
emcee0808 (4/30/2015)
Would be glad if someone could help me configure a new stored proc that will:
assumption: table2 is intially populated (basically this will serve as historical table for view); temptable...
April 30, 2015 at 6:49 am
Jeff Moden (4/29/2015)
Migrations to new servers are always a huge pain and inplace migrations are a form of suicide.
+ 1 million on the in-place migrations being suicide. To me,...
April 30, 2015 at 6:43 am
Great timing for this article. I'm planning the installation of a new server and it'll be 2012, not 2014. As much as I'd like to move to 2014,...
April 30, 2015 at 6:36 am
Without anything else to go on, I would pick the TOP 1 as well. If you post the DDL for the table and include any indexes you have already,...
April 30, 2015 at 6:21 am
Nice question. I didn't see a case where it would be required either, so I'm glad I wasn't just being short-sighted about it.
April 30, 2015 at 6:10 am
Viewing 15 posts - 6,121 through 6,135 (of 9,399 total)