Viewing 15 posts - 136 through 150 (of 217 total)
Operating system is Windows Server 2008 R2 Enterprise (SP 1) 64-bit
The RDBMS is SQL Server 2008 R2 Enterprise (also 64-bit)
The only SQL Services running on it are the database engine,...
December 6, 2011 at 3:46 pm
The applications besides the SQL Server Database Engine and SQL Server Integration Services are small & all are concerned with loading data into the server. (One example is using...
December 6, 2011 at 3:39 pm
What is your recommendation for Max Server Memory setting. The server has 144 GB of RAM (not 24 - my bad). It runs the database engine and SSIS,...
December 6, 2011 at 3:23 pm
Correct me if I am wrong, but this reads like a classroom problem. I'm happy to help you with it, but only if you promise to read through my...
December 5, 2011 at 5:29 pm
I wrote this using a common table expression. It is just another way of writing a sub-query in SQL Server. I like CTE's because they take the sub-query...
December 5, 2011 at 11:44 am
I'd go for the MCTS certifications in database administration and database development first.
If you've been working on this stuff for 4 years, I imagine you will find both tests pretty...
December 2, 2011 at 2:27 pm
It sounds like a sub-query.
There are a number of ways to do this. You could put the first query in a CTE and then reference it in the main...
December 2, 2011 at 2:14 pm
The short answer is "Yes, SQL Server is designed for that sort of thing." The long answer is "It depends."
It depends on what edition of SQL Server you are...
December 2, 2011 at 12:22 pm
Someone posted this idea on Twitter. It is similar to yours, but doesn't require an update to the stored procedure.
Add a first step to the job which checks for...
December 2, 2011 at 10:50 am
Now that is a clever solution, but I was hoping for a way to do this in SQL Agent. I would prefer to be able to change a job...
December 2, 2011 at 10:25 am
Dev (12/1/2011)
By using Sync Framework, developers can build sync ecosystems that integrate any application with any data from any store that uses any protocol over any network.
However...
December 1, 2011 at 9:41 pm
Who is this who darkens understanding with his counsel? May Codd rebuke you!:angry:
November 30, 2011 at 7:28 pm
I do appreciate the information, but that sounds an awful lot like a marketing spiel! 🙂 I mean, it sounds great, but what does it actually mean?
It sort of...
November 30, 2011 at 6:28 pm
Todd, you are absolutely right. You did a lot of work to clean up that code. It does read like something generated by an ORM tool and a...
November 29, 2011 at 9:34 pm
Add the AuditLog table back to the end of the from clause with an OUTER JOIN, like so:
RIGHT JOIN tblAuditLog ON tblItems.ITE_ItemCode = tblAuditLog.AUD_ItemCode
That should work.
November 29, 2011 at 2:00 pm
Viewing 15 posts - 136 through 150 (of 217 total)