So you have an instance called CLUSTERNAME\RESOURCENAME and you want to be able to connect to it by typing just RESOURCENAME?  I don't think SQL Browser can help you with...

Not so.  DBCC CHECKDB verifies that the database is free from corruption, as you say.  Verifying the backup performs a check on the backup file.  It's possible to have a...

Merge replication is probably the way to go here.  You could try rolling your own solution with triggers, but I guess it would soon get out of sync.

John

Same principle.  Fail over all AGs to one node, do whatever maintenance you need on the other, then do it again in reverse.  I take it you don't have any...

Fail over so that both/all instances are on Node 1.  Change the service accounts on Node 2.  Fail over both/all instances Node 2.  Change the service accounts on Node 1. ...

There may be a more elegant way, but this works:

DECLARE @CalcField1 smallint;
DECLARE @CalcField2 smallint;
DECLARE @CalcField3 smallint;
DECLARE @CalcField4 smallint;
SET @CalcField1 = RAND(CHECKSUM(NEWID())) * 100;
SET @CalcField2 = RAND(CHECKSUM(NEWID())) *...

Using sysname in this instance, and appropriate data types in general, won't in itself prevent SQL injection - it's just one more line of defence.  It's more difficult for a...

Richard

Your hunch in your original post was correct - you can't parameterise the database name and table name.  I don't understand why you want to change it from how it...

It should work like that.  You've probably got a little syntax error somewhere - that's all.  What is the error message that you get?

John

Keep an eye on the free space in the files, and extend the files when it approaches zero.  Likewise, keep an eye on the free space on disk, and extend...

Matthew

I think I've wondered this myself in the past, but ended up having to reinstall.

Does your application not allow you to specify a connection string?

John

Well, if we don't know what your real data looks like, it's difficult for us to help.  That's why I asked for representative sample data along with expected results.

John

What indexes do you have on the tables?  Please post an actual execution plan for the query (the .sqlplan file, not just a picture, please).

John

So your actual code really really uses only one line of data?  If that really is the case, why do you need MAX, DISTINCT and PARTITION BY?

John

Looks like your browser or something else has changed the less than sign into the HTML code "<".

John