But then I still have to do a join. If I make it an indexed column I can just select from one table. For getting records as of prior dates, the...
Wow - I'm lucky I don't have to deal with 350 million records. I'm well under 1million in most cases. Another thing I was thinking about doing -...
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 want to bump this post up as it seems to still be happening. Does anyone know of any background SQL jobs or proccesses that could reset an...
Does nobody else have any ideas for me? The link you provided Satya is helpful, but does not mention anything about TFS. It does talk about 3rd party...
Thanks for the reply Andy. I have done something similar to you at another job. We used to script out all the objects once a week, check everything...
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...
Am I mistaken or was there a way in SQL Server 2000 to do this via Generate Scripts wizard? Does anyone know if it is back in SQL 2008?
Does this mean that there's no inherent way in SQL Server to do this?
Thanks. I saw that but it doesn't seem to be the right option. When that is checked, and the object exists, it just skips it entirely. I want it to...
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...
True. I guess I just wanted confirmation for myself as to why it's not a good idea. I told them here that floats shouldn't be used for storing money...
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...
Actually, I just answered my own question via BOL: --Create a linked server. EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',...
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...
Separate names with a comma.
