Bhuvnesh

Forum Replies Created

Viewing 15 posts - 436 through 450 (of 2,463 total)

RE: How To Validate in Procedure

sarwaanmca (1/23/2013)
1)Mnth Column Should be Not Null
Add in procedure
IF isnull(@Mnth , '') = ''
RETURN
sarwaanmca (1/23/2013)
The DCPI_Date Field Should be 101 Format ie,...

January 23, 2013 at 3:41 am

#1579980
RE: Primary keys

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...

January 23, 2013 at 3:29 am

#1579973
RE: two Backup of a database at same time

Zeal-DBA (1/22/2013)
just want to know, if backup is happening for a database and one scheduled job also triggered for the backup of same database at same path with same name....

January 23, 2013 at 12:33 am

#1579920
RE: tempdb files on SSD

Ratheesh.K.Nair (1/22/2013)
Bhuvnesh (1/21/2013)
Tara-1044200 (1/17/2013)
3. If 1st file is filled does it uses the second file and so on untill it max out to 1TB or 10 files any query...

January 23, 2013 at 12:28 am

#1579918
RE: two Backup of a database at same time

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)

January 22, 2013 at 5:06 am

#1579565
RE: Peer-to-peer replication and identity columns

jchamiak (1/21/2013)
In my implementation I would think that it would be desirable to have no identity ranges configured and to have replicated commands update the identity values so that...

January 22, 2013 at 5:02 am

#1579562
RE: PLE (Page life expectancy).

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://www.sqlservercentral.com/articles/Performance+Tuning/analyzingmemoryrequirementsforsqlserver/2498/
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...

January 22, 2013 at 4:42 am

#1579550
RE: Help SQL query

its bit confusing what you need .
PLease post the table definition along with sample data and expected output. then only somebody can help you .

January 22, 2013 at 4:34 am

#1579543
RE: how can i get count of sikped question depend record column and collectionofResponse column?

i am not getting what u actually need , your CTE query giving result as you require (you have shown above)

January 22, 2013 at 4:18 am

#1579533
RE: How to get started with a career

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...

January 22, 2013 at 4:05 am

#1579527
RE: Group By - Help

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...

January 22, 2013 at 3:52 am

#1579521
RE: Detect missing indexes

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...

January 22, 2013 at 3:46 am

#1579518
RE: Detect missing indexes

Dung Dinh (1/22/2013)
Do we should create a non-clustered/clustered index on GUI column?
WHat are they ?

January 22, 2013 at 3:34 am

#1579513
RE: Synch two SQL databases

vijay.garg 37998 (1/21/2013)
Both the databases are in Read/Write mode and database structure may be different at source and destination. Records should be synchronized as soon as any DML statement is...

January 22, 2013 at 3:31 am

#1579512
RE: need book on perfmon counters

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

January 22, 2013 at 3:29 am

#1579511

Viewing 15 posts - 436 through 450 (of 2,463 total)