TheSQLGuru (5/12/2016)

---

My apologies...

All of your answers you seek are available from Microsoft...

Taken from https://msdn.microsoft.com/en-us/library/ff877884.aspx

An availability group supports a failover environment for a discrete set of user databases, known as availability...

Rod at work (5/2/2016)

---

jeff.mason (5/2/2016)

---

Oh, you don't want to do that, especially in a system with MARS involved. That would cause multiple recordsets potentially. You probably want to make...

Bharatvip (5/11/2016)

---

We are moving 6 production databases from one physical server to another. The drive numbers and names on the new and old servers do not match up, but we...

rgoolio32 (5/11/2016)

---

Hey,

I am trying to write a query where I group my data by a string all my parameters are integers or date/time so i can use max,sum... functions to...

M Joomun (5/11/2016)

---

I import a couple of text files (CSV) into a temporary table from a DOTNET application using the SQLBulkCopy command. This all works fine, but after the import...

darklight_arizona (5/10/2016)

---

Thanking You all

Is there any way to create a unique key on a column in SQL SERVER 2008 without removing duplicates rows. We can't remove duplicate rows due to...

Granting roles in databases does not grant them access to the server. Give them an AD group, if they don't already have one and grant that group access to...

info.sqldbamail (4/28/2016)

---

Thanks for your answers, i had set my Max memory setting to 50 GB and now Target Server memory is showing as 51452 MB in performance counter so now...

mike 57299 (5/2/2016)

---

I have a SQL 2012 Server. Our data is stored on a Dell SAN. All of it is connected using 10g TP. I have 22...

DELETE FROM...

I took it to meant a configuration table with column names, however you are correct if its table names and the underlying column count can not be known ahead of...

OK. This relies on the number of columns being known in advance and the data types also being known.

SELECT 'Car','Boat','MotorCycle','Scooter' FROM T1

This returns a row of data containing the...

Phil Parkin (5/3/2016)

---

Smendle (5/3/2016)

---

You can do this within SSIS. Its a populate SQL from variable, while the column names don't have to be the same I do believe the...

PSB (5/3/2016)

---

Hi,

I need to wipe out just today's data and insert new ones . Yesterday's data should be untouched . But the procedure is wiping off yesterday's record using the...