server: 224GB, sql server: 170GB

TheSQLGuru (2/2/2015)

---

Are you all patched up? I seem to recall a patch in a CU that may help with this issue. Start reviewing all the SP/CUs you don't...

simple

create database example

GO

USE example

GO

Create table tbl_a (email varchar (20),membershipexpiry date)

insert into tbl_a VALUES

('a@a.com','01-Jan-2012'),('b@a.com','01-Jan-2013')

GO

Create proc proc_a

@email varchar(20)

as

declare @v-2 date =

(select membershipexpiry from tbl_a where email = @email)

if