Viewing 15 posts - 436 through 450 (of 2,462 total)
sarwaanmca (1/23/2013)
1)Mnth Column Should be Not Null
Add in procedure
IF isnull(@Mnth , '') = ''
RETURN
sarwaanmca (1/23/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 23, 2013 at 3:41 am
m.rajesh.uk (1/22/2013)
can u give any suggestions on it. i have to review the structure .
Can you broef what kind of suggestion you are looking here ? primary is recommended...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 23, 2013 at 3:29 am
Zeal-DBA (1/22/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 23, 2013 at 12:33 am
Ratheesh.K.Nair (1/22/2013)
Bhuvnesh (1/21/2013)
Tara-1044200 (1/17/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 23, 2013 at 12:28 am
Both will go smoothly as sql server will start them sequentialy though there will be IO usage (might be contention if the disk is slow)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 5:06 am
jchamiak (1/21/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 5:02 am
ben.brugman (1/22/2013)
Any suggestions how to catch the processes which cause the drop in PLE ?
it means you have buffer cache issue and IO contentions
see these links
http://sqlblog.com/blogs/buck_woody/archive/2010/06/29/the-windows-page-file-and-sql-server.aspx
http://support.microsoft.com/kb/889654/en-us
and take...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 4:42 am
its bit confusing what you need .
PLease post the table definition along with sample data and expected output. then only somebody can help you .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 4:34 am
i am not getting what u actually need , your CTE query giving result as you require (you have shown above)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 4:18 am
sagarkasukurthy (1/22/2013)
Would my experience in the previous job in Cerner and the student jobs count as experience when I am applying for jobs.
might be or might be not from...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 4:05 am
PLease post table definition along with sampled data and also the expected output. people here steal time from their busy scehdule sometimes they dont have enough time to frame...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 3:52 am
Dung Dinh (1/22/2013)
I mean that the columns with data type = uniqueidentifier.
people use them as a key part though it is not recommended to have lengthy keys or indexes...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 3:46 am
Dung Dinh (1/22/2013)
Do we should create a non-clustered/clustered index on GUI column?
WHat are they ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 3:34 am
vijay.garg 37998 (1/21/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 3:31 am
rajkiran.panchagiri (1/22/2013)
Am ready to purchase a material on perfmon counters. Please suggest a best materail on this.
see the links provided by anthony above
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 3:29 am
Viewing 15 posts - 436 through 450 (of 2,462 total)