Estimated Number of Rows to be Read

Rob Farley uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

Find and Remove Duplicate Rows from a SQL Server Table

Though duplicate rows are bad practice, sometimes they're necessary for a short time. But how do you clean your tables when they're no longer needed? Sergey Gigoyan provides a few different solutions.

Fun with OVER

Generate row constructors for existing data

Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard

RE: HELP! Production down with 17207 : udopen: Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical device d:\Program Files\Microsoft SQL Server\MSSQL\data\templ

billkrohe: Did it resolve your problem?

RE: Need Ideas for Passing a variable(filename) then importing file

Thank you for the suggestions - However, my VB skills are limited - I was trying to use DTS to create the global variable.  I understand how to set the variables - What I am still confused on is how to set the value of the variable when it is constantly changing. According the the […]

RE: questions regarding full transaction log

if ur not using incremental backup for ur db then i would suggest u to change the recovery model to 'simple'. and make sure the autogrow property is checked. then stop n start the services.if sql say tran log is full, it might be a harddisk runnin out of space...just double check on that....hope this helps 

RE: Migrating SQL Server Jobs

There is a DTS task in SQL2000 to transfer jobs.  The source can be a SQL 7 server and you can select the specific jobs you want to transfer.