J Livingston SQL (4/29/2013)

---

Hi any pointers to official / supporting docs...

Now, if we could just get people to use the semicolon statement terminitor correctly instead of using it as a begininator at the start of a CTE definition. 😉

e4d4 (4/29/2013)

---

http://technet.microsoft.com/en-us/library/ms175191.aspx

You need a running instance of SQL Server, so at least a SQL Server service and a SQL Server Browser if witness is on named instance and you connect...

S_Kumar_S (4/29/2013)

---

One question to all:

If I have data like this, where there is only one clustered index on table and index size is 2976 KB.

name ...

Okay, I will say it explicitly instead of implying it. Look at the code you use to run the index maintenance, is it running the rebuilds/reorgs as a single...

If t-log growing to 160GB over 2 hours and you are running t-log backups every 20 minutes, sort of sounds like the index maintenance process may be running as a...

In all my years in this business I have never seen a lookup table remain static. New values are...

prb88 (4/29/2013)

---

thanks but i am told not to use a view but to actually update the reasonforreferral column from table a with the description column from table B with an...

Look up CREATE VIEW in Books Online, but to help:

create view dbo.MyView

as

select

a.DIVISION,

a.SUB_UNIT,

b.Description as ReasonsReferral

from

dbo.TableA...

rdeheld-535532 (4/24/2013)

---

Yes It does require license

Read Multiplexing:

"The number of tiers of hardware or software between the SQL Server and the user or devices that ultimately use its data, services, or...

You don't need all those RETURN statements in your code:

declare @V_AreaId int = 1

declare @V_Area nvarchar(30)='xxx'

declare @V_Pincode nvarchar(10) ='35646'

BEGIN TRY

BEGIN TRANSACTION

IF...

Eddie Wuerch (4/27/2013)

---

This is pretty much what the NTILE() windowed function is for - equally dividing a results set into x number of pieces. Unlike throwing calculations at the min...

Okay, not sure what is going on here as I am not making much sense from your ramblings.

What I did get is that the primary key columns of the four...

No Sergiy, I would have to agree with opc.three, you weren't being professional in your...

IniJoy (4/26/2013)

---

A second layer to this scenario:

Is there a way to add a "top 10" factor to only select the ActivityID's whose aggregates are in the top 10 #'s for...