establishment

skilly2 (5/11/2015)

---

I have a stored procedure that runs every 5 minutes. I have one block in the procedure that will only run if there are records in a temp...

Lynn Pettis (5/11/2015)

---

When you use the GUI to make some changes to a table, SSMS will...

Bill Talada (5/11/2015)

---

Regular functions store the return value as parameter zero in sys.parameters but I can't find the TVF table definition for the following sample function. Is the function's...

It is a sensitive subject:-D

😎

Raymond van Laake (5/11/2015)

---

Sounds like it should work, however when I change my formula to:

RTRIM(([dbo].[fx_formatTelnr]([project],[user_tel])))

I still get the error.

What strikes me is the following:I am trying to persist the field...

Breakable

Further on Jeff's post, simpler logic can be wrapped in SQL deterministic functions.

😎

This function is not deterministic although it is only a simple subtraction of two columns

CREATE FUNCTION dbo.SVF_SUBTRACT_TAX_FROM_TOTAL

(

...

Ambiguity

Jeff Moden (5/10/2015)

---

Have you actually ever done a measurement on this subject? I could be wrong in some instances but it would appear the space savings are not true when...

Most common use I see...

GilaMonster (5/10/2015)

---

Eirikur Eiriksson (5/10/2015)

---

Ken Davis (5/9/2015)

---

I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB....

zogher (5/9/2015)

---

Hi,

Thanks for the reply.

Couple of things to note (yes, my example is rather simplified), I will try...

rkrpat (5/10/2015)

---

Hi,

We are working in a Merge replication environment where we have SQL Server 2005, 11 publications and 2 subscribers.

We used to get lot of incidents from the Application...

Quick suggestion, use OUTPUT parameter for the procedure

😎

/* Procedure #1 */

CREATE PROCEDURE [dbo].[GetUserIDbyUserName]

@UserName nvarchar(100)

,@UserID uniqueidentifier = NULL OUTPUT

AS

SELECT

@user-id...