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.
Really?...
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
Rated...
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
Standard:
At least max. limit is raised from 64GB to 128GB now
Enterprise:
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 @@)
http://us.demo.qlikview.com/download/[/url]
64-bit is 255MB
December 17, 2012 at 12:36 pm
Link to PDF worked for me this morning (Nov 6th)
http://assets.red-gate.com/community/books/assets/sql-server-hardware-ebook.pdf
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 myTable
set @newValue=myField=
CASE
WHEN myField='A'
THEN 'X'
ELSE 'D'
END
WHERE myID= 100
Most of the time I just do SELECT directly
but temp...
February 8, 2010 at 9:24 am
See if this link helps (thanks Google)
http://www.mssqltips.com/tip.asp?tip=960
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
Viewing 15 posts - 1 through 15 (of 548 total)