Viewing 15 posts - 2,131 through 2,145 (of 3,061 total)
Steve Jones - Editor (4/5/2010)
I'll stand by my "design w/o RI is poor."
May I substitute the word poor by the word wrong? 😉
April 5, 2010 at 9:07 am
BSavoie (1/5/2010)
As developers, we tend to think of a log as some container that records some non-critical detail about an event that happened in the past.
That's one of the many...
April 5, 2010 at 9:02 am
Use data conversion task instead of sql exec task.
April 5, 2010 at 7:43 am
Three reasons not to do it...
1- Security administration,
2- Backup/Recovery strategy,
3- Escalability
April 5, 2010 at 7:14 am
Not totally sure about the question but sp_MSforeachdb allows to execute a T-SQL statement against all databases in the SQL Server instance.
Hope this helps.
April 5, 2010 at 7:09 am
Most DBA in the team I work with are over 40 years old; not too late for you.
Reading your post it looks like you have some exposure to SQL Server...
April 5, 2010 at 6:53 am
david_wendelken (4/4/2010)
April 5, 2010 at 6:42 am
I would start by installing SQL Server and playing around on included test database, BOL will be your best friend throughout your career.
Good luck.
April 5, 2010 at 6:34 am
Ramoncito Medina (11/22/2007)
It's not joined, the data are directly inserted in the table from a text file via...
April 4, 2010 at 4:27 pm
Ramoncito Medina (11/20/2007)
What would be the probable cause of the duplication of the records?
Poor design - there is no PK in affected table or PK was poorly defined otherwise no...
April 4, 2010 at 4:21 pm
Actually I was more concerned about "Sometimes the business requirement is to BE SEEN to have an application on a topic and pretending it works correctly "... scary :crying:
April 4, 2010 at 4:13 pm
Tom.Thomson (4/4/2010)
If I seem to be confrontational here, that's intentional - David Portas' confrontational and unsubstantiated claim about defects in SQL compared to languages like C++ which contain far more...
April 4, 2010 at 9:55 am
david_wendelken (4/4/2010)
April 4, 2010 at 9:48 am
No need for an inline view a.k.a. subquery.
Just joing Employee table with itself - use different aliases.
April 4, 2010 at 9:43 am
Paul White NZ (4/3/2010)
PaulB-TheOneAndOnly (4/2/2010)
sumit.joshij (4/2/2010)
April 3, 2010 at 7:55 am
Viewing 15 posts - 2,131 through 2,145 (of 3,061 total)