Viewing 15 posts - 1,861 through 1,875 (of 6,395 total)
ram1447 (10/31/2015)
We use SQL server always on feather on my database and we distribute statement on main database server and mirror database server for raise performance.
My police for split...
November 2, 2015 at 1:49 am
If you have the licenses to cover the cores in use then yes.
SA gives a bunch of different features like a single passive failover node, upgrades etc.
But as long as...
November 2, 2015 at 1:45 am
RECOMPILE
select a.* from a inner join b on a.id = b.id option (recompile)
October 30, 2015 at 9:48 am
Ed Wagner (10/30/2015)
anthony.green (10/30/2015)
happygeek (10/30/2015)
Ed Wagner (10/29/2015)
Revenant (10/29/2015)
happygeek (10/29/2015)
whereisSQL? (10/29/2015)
Ed Wagner (10/29/2015)
Luis Cazares (10/29/2015)
DonlSimpson (10/29/2015)
anthony.green (10/29/2015)
Ed Wagner (10/29/2015)
anthony.green (10/29/2015)
crookj (10/29/2015)
TossSalad
Greens
Me
Myself
Irene
Good Night
Dream
maker
catcher
Pitcher
Beer
Sew
Needle
October 30, 2015 at 9:39 am
Take a look at sys.fn_hadr_is_primary_replica, its written to return true false depending which node in the group is the primary.
Also these two links may help
October 30, 2015 at 8:18 am
Always On Failover Cluster
or
Always On Availability Groups on a Always On Failover Cluster
Always On is just a marketing term, generally dropped as it means nothing really, so generally detail if...
October 30, 2015 at 4:02 am
On the trace imported disable event requirement checks, that always works for me
October 30, 2015 at 3:51 am
Your ReplyTo is @To, that needs to be @From
Also not a fan of sp_OA calls, they use memory outside of the SQL allocation, have you looked at converting this to...
October 30, 2015 at 2:51 am
Snapshots create sparse files. So as data changes, the original data is pushed into the sparse file to ensure the snapshot is a snapshot of that time it was...
October 30, 2015 at 2:46 am
happygeek (10/30/2015)
Ed Wagner (10/29/2015)
Revenant (10/29/2015)
happygeek (10/29/2015)
whereisSQL? (10/29/2015)
Ed Wagner (10/29/2015)
Luis Cazares (10/29/2015)
DonlSimpson (10/29/2015)
anthony.green (10/29/2015)
Ed Wagner (10/29/2015)
anthony.green (10/29/2015)
crookj (10/29/2015)
TossSalad
Greens
Me
Myself
Irene
Good Night
Dream
maker
catcher
Pitcher
Beer
October 30, 2015 at 2:39 am
There is also the hidden same drive scenario also.
Is the drive split into multiple partitions? EG a 500GB drive split 250GB / 250GB labeled with different drive letters. ...
October 30, 2015 at 2:34 am
Sure there will be a better way to do it than a cursor.
Could you please provide definitions of the tables in question, with some sample data and an expected outcome.
Please...
October 30, 2015 at 2:26 am
Please don't cross post questions, it fragments replies.
http://www.sqlservercentral.com/Forums/Topic1732107-3411-1.aspx
October 30, 2015 at 2:25 am
Warning can be skipped, errors cannot.
Your installing SQL on a server edition that has Windows Firewall, it is warning you that you must change the firewall settings in order to...
October 30, 2015 at 2:21 am
You running any server audits?
October 30, 2015 at 2:15 am
Viewing 15 posts - 1,861 through 1,875 (of 6,395 total)