Reputation
1,246
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 10 41
Impact
~77k people reached

Feb
12
comment Sum(Case When) Question
yup, without running the code myself that seems to be the issue.
Feb
6
comment Why would a default constraint be missing an index?
@DanGuzman that seems to have done it.
Feb
6
comment 1 hour query, is there another way to do this?
@koljanep i didn't expect it to work right out of the box, was more trying to provide a general layout for you to use. As far as i can tell, without the actual database to play with, this should work.
Feb
6
comment Medical History - Is this DB properly design?
What happens when a patient changes doctors?
Feb
6
comment Updating one table from another table where non-primary-key field is similar string
@CarenRose yeah it sucks when you get so far and then realize that you're missing vital data. but it's always best to do it this way so that you can 100% ensure data quality.
Feb
3
comment Why would a default constraint be missing an index?
@a_horse_with_no_name added
Feb
3
comment Data containing list of all the domain names. MongoDB or MySQL?
This sounds rather simple for a database solution. What are your expectations for inserting, updating, and deleting the data? What technology/ies will you be using to access this data?
Jan
29
comment MySQL Count where all conditions evaluate to 1
@user57391 I don't knwo what you want me to see
Jan
26
comment MySQL Count where all conditions evaluate to 1
how much data is this running on? Also, are there any indexes on the table?
Jan
26
comment how to check whether Oracle database is accessed or not?
This is a rather empty answer. Could you add more to it to make it more helpful?
Jan
15
comment Database structure for hierarchical quiz?
this doesn't help you writing the code, but tools such as Survey Gizmo and Survey Monkey can do this for you, if that's an option.
Jan
15
comment Save multiple SQL jobs in single files
Are you needing a single file for each server's jobs, or a single file for ALL of the jobs on all of your servers? Also, what do you intend to do with this?
Jan
13
comment High CPU in SQL Server supporting SharePoint databases while running FAST search crawl
@DaniSQL i recommend putting your last comment as the answer to your question and accepting it.
Jan
9
comment Difference in number format (comman and dot) on SSMS and SSIS
i have a feeling it my do with the language settings of either SSIS or whatever you're opening the flat file with, but beyond that I'm not sure.
Jan
9
comment Difference in number format (comman and dot) on SSMS and SSIS
What do you get when you actually export the data to the flat file? Dot or comma?
Jan
9
comment Difference in number format (comman and dot) on SSMS and SSIS
How are you trying to display this in SSIS? Do you mean reporting services?
Feb
7
comment Is there a way to use a SQL Server 2000 database in SSIS 2012?
@Zane Ehh, we've finally gotten rid of it. Now to update all the things.
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 i didn't include it, but there were messages in the app log that explicitly stated "backup of database x failed".
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 scheduled sql server maintenance plan.
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 yes, all databases. yes, it works at toher times, but seems to always fail on sundays.