Here is a code sample, that you might want to include in a job set to run on a daily basis. Insert the results into a table for review...

Another thought for the long haul ..

Database Mirroring (SQL Server)

SQL Server 2012

http://msdn.microsoft.com/en-us/library/ms189852.aspx

which states:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this...

Denise McMillan (3/30/2012)

---

Thank you for those ideas.

I was hoping to do this without a second table though. I'm not using all the fields in the table to get the...

Nice easy one to end the week ....

A quick and simple answer is No you can not

CREATE TABLE #A(Age INT,Id INT IDENTITY(1,1))

DECLARE @X INT

SET @X = 20

WHILE @X < 30

BEGIN

...

Like so much of SQL the answer is it depends. In this case is the number of rows which will remain, a in significant number or percentage of the...

Learned something .... thanks

Look at using ISNULL

http://msdn.microsoft.com/en-us/library/ms184325(v=sql.100).aspx

1. Is the table a heap (no indexes) or does it contain indexes?

2. ...

Koen Verbeeck (3/28/2012)

---

GSquared (3/28/2012)

---

Koen Verbeeck (3/28/2012)

---

David Burrows (3/28/2012)

---

A milestone is a milestone is a...

What is the compatability level of you Model DB ?

davidandrews13 (3/27/2012)

---

surely it doesn't matter if you do SELECT *?

every time i create or update a view...

To start the discussion - Tech Specs Shall we discuss the change or rate of change (now increasing) of the Worlds population. Whose estimates (United Nations forecast, or...

Look I am old with grey hair but so far no ulcer's no uncontrolable...

Look at using the REVERSE function, something like this:

DECLARE @T VARCHAR(50)

SET @T = 'building,test ,test,Åland ,'

SELECT REVERSE(SUBSTRING(REVERSE(@T),2,LEN(@T)))

Result:

building,test ,test,Åland