rob.vig (7/16/2012)

---

Why all the "Why's"???

Like I said... this is my first T SQL statement!

I wanted to place 2 INSERT's and one DELETE. If they didn't work, I want to...

sudhakara (7/16/2012)

---

When i run following query select GRANTOR from [master].[dbo].[SYSREMOTE_COLUMN_PRIVILEGES] on sql server 2000 version its throuwing following error message.

Msg 201, Level 16, State 7, Line 1

Procedure...

Well, Sean had a good point... but I will try to give you a "hint" on what I would do. Write a stored proc that takes a date range...

The problem is that it is a cursor and a function 🙂 Can you give us the stored proc that runs? This will help us to help you. ...

Take whatever stored procedure is writing to table A and make sure that it also writes to table B. You can do it at the same time using the...

Something like this?

CREATE TABLE #temp(subject_id int identity(1,1), measurement numeric(8,2))

INSERT INTO #temp (measurement)

SELECT 5.0

UNION ALL

SELECT 6.2

UNION ALL

SELECT 4.6

DECLARE @mean numeric(8,2)

DECLARE @ss numeric(8,2)

DECLARE @n numeric(8,2)

DECLARE @stdDev numeric(8,2)

SET @n = (SELECT COUNT(1) FROM...

TheSQLGuru (7/10/2012)

---

SQLKnowItAll (7/10/2012)

---

Well, I might have made an @$$...

blampe (7/10/2012)

---

Jared,

The data is being used in a production environment and the purpose of this data obfuscation is just to prevent any sensitive data from being seen by people...

Just curious... Why are you giving access to sensitive information to people who don't need it. If it is scrambled, why not just deny permission to the column? Or,...

Hmm... Not completely sure, but I would personally not be altering backup related tables. Maybe someone else will have some input.

I would check with the company that makes said "snapshot" device and find out why they are writing to the database or exactly what they are doing with SQL Server.

I have only seen and experienced performance gains with a pull subscription over a WAN. Have not researched or experienced anything else. We always set ours up as push,...

A heap is actually a table without a clustered index (i.e. order of the data itself). You can have non-clustered indexes on a heap. Sometimes it is more hassle to...

You don't use PRINT before the stored proc. Also, this sp shouldn't be used since it is deprecated. http://msdn.microsoft.com/en-us/library/ms188424.aspx%5B/code%5D

My first question would be "Do you know why this is partitioned?" What's the reasoning?