Viewing 15 posts - 571 through 585 (of 2,462 total)
lonhanner (1/6/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 12:42 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 12:29 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 12:24 am
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 12:17 am
opc.three (1/6/2013)
Bhuvnesh (1/6/2013)
certainly , we can have trigger (instead of) but i will suggest to set the trigger on table.
That likely will not help the situation. There is unique value...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 6, 2013 at 10:58 pm
Bhuvnesh (1/4/2013)
well to me it doesnt look like that this function itself might create some problem.as it doesnt have any kind of comple logc or calculation.
i am taking my...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 6, 2013 at 10:42 pm
certainly , we can have trigger (instead of) but i will suggest to set the trigger on table.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 6, 2013 at 7:26 am
I wil favor here to set the profiler trace (
beware of filters and required columns
), see if you catch there something.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 6, 2013 at 6:53 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 6, 2013 at 12:34 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 4, 2013 at 3:19 am
opc.three (1/2/2013)
I was only looking at the execution plans to show that OFFSET can replace TOP in many instances, TOP being proprietary, OFFSET being ANSI-Standard SQL.
opc, can you please...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 4, 2013 at 2:39 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 4, 2013 at 1:03 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 4, 2013 at 12:56 am
ScottPletcher (1/3/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 10:38 pm
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 4:35 am
Viewing 15 posts - 571 through 585 (of 2,462 total)