Usually only Log Reader and Distribution agents running continuously. So, you don't need to stop Snapshot.

As to how long it can be paused, it depends on you environment. If replicated...

• This reply was modified 6 years, 3 months ago by rVadim.

I don't see how this is possible. UNION is a combination of rows, provided that order and number of columns are the same and have compatible datatypes. JOIN is more...

I don't think it works like this. Parameter is what you put on the WHERE clause. If  you want change table name, concatenate:

SELECT @SQLString = N'Select *...

Your question is somewhat contradictory (or may be I'm reading it wrong). If you want the type to be used by others for any number of strings of any length...

@Name would be a parameter in my update procedure. Unencrypted string that needs to be encrypted. You can  replace it with 'My name' string from your example.

When you said "This...

Here is what we do in the beginning of update procedure:

  DECLARE @EncryptedName VARBINARY(68);
   
  IF NOT EXISTS(SELECT * FROM sys.openkeys WHERE key_name...

If I understood you correctly:

SELECT FName, Lname, COUNT(*)
FROM YourTable
GROUP BY FName, Lname
HAVING COUNT(*)  > 1

Check log_reuse_wait_desc in sysdatabases. What it says?

LEFT JOIN will return all rows from table C and matching rows from sub query CCL. Unmatched rows on CCL side will be filled with NULLs. Total number of rows...

Worked fine this time, Thank you Steve.

One more question. When I do QotD preview can I interact with it? Like select different answers an clicking Submit?

I've asked around. Nobody confessed. 🙂  There is only handful of people with that level of access and I don't see why would anyone do something like that.

Thank you for...

Yes. That's what...

That identity column is a Primary Key enforced by clustered index. It is in production. Lowest value in this column is 2 (if I understand your question correctly).

DBCC CHECKIDENT returned...

If you provide data in the consumable, ready to run format, you would usually get more responses.

Try this:

CREATE TABLE #Temp(ColB INT, ColA INT);
INSERT INTO #Temp (ColB,ColA)
 ...

Ah, mine not going to work in one pass if there are different substrings from search_val, like this:

SELECT * INTO #Names
FROM (
SELECT 'Timothy Johnson Timothy' AS Name...