Viewing 15 posts - 1,546 through 1,560 (of 6,400 total)
Taken from the MS 2016 Licensing Guide
Licensing for High Availability
SQL Server software can be configured so that if one server fails, its processing will...
May 5, 2017 at 6:44 am
Take a look at sys.database_principals, that will give you the list of each user within the database.
You can then look at something like the undocumented sp_msforeachdb procedure to...
May 5, 2017 at 6:03 am
What errors do you get when trying to start the services?
Also check the services are not set as disabled.
You may also only have RDP rights to...
May 5, 2017 at 4:52 am
Not possible as they are separate Windows clusters.
Your options would boil down to doing things like SSIS, Replication, Log Shipping etc to transfer data/databases between the 2 clusters.
May 5, 2017 at 4:29 am
May 5, 2017 at 4:12 am
If your worried about SQL Injection, you could have a look at Gail's "catch all" query and how she gets around SQL injection.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
While I appreciate...
May 5, 2017 at 2:52 am
The machines all need to be part of the same windows cluster in order to do AOAG's. Can you do a geospatial cluster where you have servers in multiple sites?
May 5, 2017 at 1:46 am
what data type is @remotesql1, that's the only parameter I can't see in the declare list, guessing its varchar
May 5, 2017 at 1:14 am
My view on this is to create a computed column on the table in question which removes all the spaces and then stick an index on top of that column. ...
May 3, 2017 at 9:23 am
Giving Domain Admin to a service account is bad practise.
Generally it should just be a standard blank Domain User account or if you can a managed service account.
May 3, 2017 at 8:56 am
Sorry unsure what happened to that link
Corrected below
May 3, 2017 at 8:25 am
The compatibility levels only make certain things behave like that version, its not a setting to make the 2016 engine behave like the 2008R2 engine for a specific database, the...
May 3, 2017 at 7:52 am
May 3, 2017 at 4:23 am
No I didn't notice anything strange in RAM utilisation, but something was causing the proc cache to not store any records. After reducing SQL's RAM on the server I was...
May 3, 2017 at 3:21 am
gkochkin - Wednesday, May 3, 2017 2:25 AMwhat's the point? You think it might be not enough memory for the OS?
Yeah,...
May 3, 2017 at 2:38 am
Viewing 15 posts - 1,546 through 1,560 (of 6,400 total)