Hi - in my application we have several historical tables that have a column such as "AsOfDate" and store snapshots of the data on certain dates. We...
I've been searching old posts and articles here and other sites. Everyone is talking about how important it is to have source control etc etc etc,...
Hi - I'm facing an interesting situation which I never encountered before. I'm writing a procedure to be placed in an application that is written by...
I always went under the assumptions that while you had to be very careful when using user defined functions, very simple ones would have little or no...
In SQL Server 2000, in the generate scripts wizard, you used to be able to generate scripts that did a DROP and CREATE after checking for existence....
Hello all, I have a situation where we have a table that 99% of the time is empty. It's an outgoing message queue table. Once messages are picked...
I know its wrong but I'm hoping somepeople here can help me understand the implications. At my last two jobs worknig with financial systems, we used...
This is going to sound crazy - but I'm writing a procedure that needs to pull data that is stored in an Access database somewhere else in the firm....
Not sure if this is the right place for this post or not. I'm developing an application that has sensitive data stored in a few tables. There are...
Here's a SQL puzzle I'm facing now. So far I have two unslick ways to solve it, and one of those doesn't even work nicely. I have a table. My goal...
Hi all, I was hoping someone could shed some light on what MS best practices say regarding quoted identifiers and aliases? Almost everywhere in our...
Hi, I've discovered a problem/inconsistency with the DATEADD function. I'm wondering if anyone else has run into this and has any suggestions for...
Hi, Since I've been coding stored procedures, I've always began and ended my procs with BEGIN/END blocks. Someone just pointed out to me that those...
We have a typical web application set up. ASP, with COM middle tier, and SQL Server 2000 database. Here's the question. What happens in the scenario...
Hi all, After some research online, I've noticed some confusion around about the differences between a CacheMiss and Recompile. To my knowledge, a...
Hi all, We have a bunch of UDF's which take a string as a parameter, and then based on a number of CASE statements, return formatted string back. We...
Hi,<br /><br />Does anyone know of a way to use the ALTER command to add a column at a certain position in SQL 2K? I want to add a new column to an...
Hi All, We have the following Query: SELECT SS.SecID FROM dbo.vSecurityActive SS INNER JOIN dbo.RateReset RR ON SS.SecID =...
One more question for you guys: Regarding the use of Dynamic SQL and EXEC statements, is there any performance benefit to using one option over the...
Hi all, I was wondering if there are every certain situations where it could be ok to put an index on a bit? I've read in many places that it's not...
Separate names with a comma.
