Running Total Performance

Solving the Running Total and Ordinal Rank Problems (Rewritten)

Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot

Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables

Lynn Pettis gives us a look at a new way to solve a T-SQL problem.

RE: problem with linked server

Hi Ilijana,I am not familiar with omitting the database name but it seems that omitting the owner name enables the MS-data-access-oracle-unit  (I think this is that MSDAORA) to find the table you want where as using "JZOB" as owner cause this unit to access a non existing object. As far as there are only one table IZDVOJENA_OR the second […]

RE: TRANSFORMING DATE USING DTS

Define your output columns on your target table. Set transformations for all other matching columns. Create ActiveX script to parse the input date to the separate output columns.

RE: Identity Column

1. identity columns can't have null values 2. To change an identity column into another one add another column with same data type, update the new columns value and remove the identity column 3. You can do a similar thing to convert an int column into identity with out the update, since indentity columns cannot […]

RE: Other Query languages?

Morgen Frank, Yeah there is also RitchSQL, although I wouldn't recommend it Laters Ritch *I didn't do anything it just got complicated*

RE: Create DB Users for New Databases

Thank you very much for the input. Any suggestions on how to automate the process of adding hundreds of users? Thanks again. WM

RE: Scheduling DTS Packages...

Yes, the same security is being used throughout.