Viewing 15 posts - 1 through 15 (of 548 total)
Joie Andrew (6/1/2015)Unfortunately I just found this issue on a SQL Server 2014 SP1 instance. SP1 was supposed to have fixes through CU5 applied. Apparently some fell through the cracks.
Joie Andrew (6/1/2015)
June 1, 2015 at 10:59 am
Oh man, how can they break a working feature in 2008/2012 into 2014?
Sigh, just found this issue on my 2014 Standard/Enterprise also
Good news - it's now fixed in CU4 (build...
November 25, 2014 at 1:44 pm
Perry Whittle (9/24/2014)Jerry Hung (9/24/2014)Thanks for this timely introductory article, as I am doing research on AlwaysOn this week 🙂Thank you, please rate the article if you found it useful
Perry Whittle (9/24/2014)
Jerry Hung (9/24/2014)Thanks for this timely introductory article, as I am doing research on AlwaysOn this week 🙂
Jerry Hung (9/24/2014)
Thank you, please rate the article if you found it useful
September 24, 2014 at 1:25 pm
Thanks for this timely introductory article, as I am doing research on AlwaysOn this week 🙂
Some requirements though
AG Group is only available on Enterprise edition @@ = costly. I believe...
September 24, 2014 at 12:17 pm
At least max. limit is raised from 64GB to 128GB now
True that to all new EE features, although I doubt we'll benefit from any 😛
hence we should consolidate...
May 12, 2014 at 10:00 am
Any updates to this now that SQL 2014 is released?
We aren't upgrading widely, but new SCOM 2012 requires SQL 2012, and MS has said it should also support SQL 2014...
May 12, 2014 at 9:36 am
Nicholas Cain (12/15/2008)
August 8, 2013 at 9:46 am
I tried to do this (adding SQLName\Instance2 to existing SQLName\Instance1) today (SQL 2008 SP3 cluster) and confirmed it would NOT work @@
I was hoping it would work so I can...
June 5, 2013 at 11:27 am
Direct link to download page, without registration (the link in article leads to registration before showing you this link @@)
64-bit is 255MB
December 17, 2012 at 12:36 pm
Link to PDF worked for me this morning (Nov 6th)
Thank you for the book, I'll give it a read
It's useful for any DBA who wasn't initially involved in...
November 6, 2012 at 9:29 am
that sucks.. I hope it's not backward-compatible 🙂
I don't want an expiry date on my Certificate
Also, Microsoft will increase the Certification price also
e.g. in Canada, it'll be $125 -> $150...
April 26, 2011 at 1:44 pm
Just to add, this is what shows in SQL 2005
DBCC traceon (3604) WITH no_infomsgs
dbcc page (9,1,6340633) with ...
July 29, 2010 at 2:10 pm
vfazal (2/8/2010)If you just want to capture new value in a variable:DECLARE @newValue VARCHAR(10)UPDATE myTableset @newValue=myField=CASEWHEN myField='A'THEN 'X'ELSE 'D'ENDWHERE myID= 100
DECLARE @newValue VARCHAR(10)
WHERE myID= 100
Most of the time I just do SELECT directly
February 8, 2010 at 9:24 am
See if this link helps (thanks Google)
I have done it in 2005 but not for 2000
February 4, 2010 at 3:02 pm
That is interesting, one shouldn't be able to login unless he/she belongs to a group
You could try removing permissions group by group and see (e.g. make those groups Public roles...
February 4, 2010 at 2:54 pm