lonhanner (1/6/2013)

---

I do not have any stored procedures in my database or to say I have not created any. I use parameter in vb to store the values of my...

frankly speaking , i first time heard about phd in database field :-P. i dont think any indian university provide such course (assuming you are indian 🙂 )

Anyways...

i seems that you are new to SSC .Welcome here.

one suggestion.

While posting to any forum you must include/post table defintion along with test data. it will help others to...

see below links

http://msdn.microsoft.com/en-us/library/bb500435(SQL.105).aspx

http://www.microsoft.com/sqlserver/en/us/editions/previous-versions.aspx

opc.three (1/6/2013)

---

That likely will not help the situation. There is unique value...

i am taking my...

certainly , we can have trigger (instead of) but i will suggest to set the trigger on table.

I wil favor here to set the profiler trace (

), see if you catch there something.

what i think here , external fragmentation is basically handled by sql server internally and data get inserted in mixed extent initially (i think we can keep "table having identity...

dwain.c (1/1/2013)

---

CROSS APPLY (

VALUES(High, 'High', DATEPART(dw, CAST(DateID AS CHAR(8))))

,(Low, 'Low', DATEPART(dw, CAST(DateID AS CHAR(8))))) a(Val, Type, weekday)

GROUP BY...

opc, can you please...

Where exactly you are using this function , well to me it doesnt look like that this function itself might create some problem.as it doesnt have any kind of comple...

HI Umer,

Welcome to SSC 🙂

We can certainly help you here . but for that we need table , index definition here along with some same data. it will help...

ScottPletcher (1/3/2013)

---

If you're providing data for report or any type of BI application, remove NULLs entirely. NULLs cause serious and severe logic considerations that most people don't fully understand...

Do you experience any memory issues ?

have you checked the cache too? is it playing well ?

another thing , is you log files are sitting with tempdb files ?

Also...