Viewing 15 posts - 91 through 105 (of 1,065 total)
As Derek has already suggested, it's just something you need to read up on.
Many of the terms can have more than one meaning depending on the context, so I could...
February 3, 2012 at 4:37 am
This link explains your issue... http://social.msdn.microsoft.com/Forums/en/transactsql/thread/bac1f56f-9a59-4ca6-b750-80b3f28a1f5f
January 30, 2012 at 2:20 am
That is a nice article from Paul.
From your requirements, there is one thing that would still bother me about using transactional replication...
Argument 8: There's no easy way to fail...
January 27, 2012 at 4:53 am
Have a look in SQL Server Books online (BOL)... it's all there.
BULK INSERT
[ database_name . [ schema_name ] . | schema_name . ] [ table_name |...
January 27, 2012 at 2:00 am
That does seem an awful lot of work for something that looks tailor made for Database Mirroring.
January 26, 2012 at 5:50 am
How would you revert to the original server once it's back up and running?
You would have data in the backup server that has no obvious way of getting back to...
January 26, 2012 at 3:59 am
Not sure, but the problem may be that the surrogateId column is defined as an IDENTITY in both tables.
I would only expect the parent table to be defined as an...
January 17, 2012 at 8:35 am
This is very strange!!
I think the problem you are having is with the code to fetch the child columns (which are actually parent columns as far as the FK is...
December 21, 2011 at 3:53 am
Aaron Christenson (11/26/2011)
The first step in this job is to delete the backup files from the previous day Aaron
A small point, and you may have a good reason for doing...
November 29, 2011 at 7:14 am
I think you were joining on the wrong column (title instead of Job_Title_Code)
SELECT Salary, COUNT(*) as "Total Employees"
FROM Employee
JOIN Job_Title ON Employee.Job_Title_Code=Job_Title.Job_Title_Code
GROUP BY Salary
November 23, 2011 at 2:29 am
Sean Grebey-262535 (9/30/2011)
September 30, 2011 at 7:59 am
Since you've posted this in the SQL 7/2000 forums, I'll assume you are using one of those versions, so you should be able to truncate the log with this statement...
September 30, 2011 at 7:05 am
All of this just reiterates the need to make job candidates answer real technical questions and/or sit a relevant test as part of an interview.
You have to take CVs and...
September 20, 2011 at 2:34 am
I think you'll find the SQL you've posted is for MySQL, not SQL Server.
There is no such setting as SQL_MODE in SQL Server, and your conditional table creation isn't in...
September 9, 2011 at 8:23 am
You've probably thought of this, but... depending on what proportion of the tables and/or data are going to be retained, another option is to do a backup/restore and just drop...
September 9, 2011 at 2:42 am
Viewing 15 posts - 91 through 105 (of 1,065 total)