Maybe not quite what you are looking for but you can have a view where two different users see different things depending on their scheme.CREATE...
Assuming trxdate is unique, something like this should work: UPDATE yourtable SET subp = lastnotnullvalue.subp FROM yourtable INNER JOIN yourtable...
Paging should reduce the amount of data your infrastructure has to handles and you front end should have less work to do it does not have to do the...
Seen something similar recently but I needed to use a LIKE, not =. I ended up placing the encrypted field in it's own index, not as the key as SQL...
Sorry. Did I do something wrong? Am I not supposed to post job oppertunities in this area?
Good working knowledge of MS SQL Server 2000/2005. Experience in working with multiple 50GB to 100GB mission critical databases.writing, debugging...
How an index is used is affected not just by the columns in the where clause but also by the columns being selected in the query. If SQL find all of...
How are you using the results of this function? If the funtion call is from the insert statement like this: INSERT INTO MyTable (col1, col2, col3)...
Statistics are updated every night at 1pm. I've seen this go bad just one hour after that update. Current plan of attack a combination of splitting...
If I clear the cache or update statistics the query runs fine. It's usually after the plan has been created and has been used for several hours that...
I thought I had it sorted by altering the sql but this morning when I checked profiler I see huge reads again on the same 3 tables and repeating the...
I did find something today that maybe the problem. The query uses WITH RESULTSET to support front end pagination and usually returns up to 25 rows. A...
Been working on a problem for the last 2 weeks where an about twice a day one page in our application which usually takes about half a second can...
Separate names with a comma.
