Archive for the ‘SQL Server’ Category

Sql Server Error Login

Wednesday, February 20th, 2008

Today I’m install new SQL Server I user SQL Server 2005 Enterprise. When I installed and just to login but login fail I’m stun very because several day ago I’m install sql server 2005 and use window mix mode can login . But to day I’m installed is login fail. I use this connection string like this “Data Source = AWAT-PC;Initial Catalog = DataTest;User ID=sa;Password=xxxx;Trusted_Connection=true” can’t login but I change Trusted_Connection is false can connect.

Introduction to DTS in SQL SERVER 2005

Friday, February 1st, 2008


DTS was one of the true innovations in SQL Server 7. SQL Server 2000 greatly enhanced this tool and SQL Server 2005 makes it truly a programming environment, well beyond the ETL functions of DTS in SQL Server 2000. New author Vinod Kumar gives a brief introduction to this new environment. More »

Solving the “Running Total” & “Ordinal Rank” Problems in SS 2k/2k5

Thursday, January 31st, 2008

Jeff Moden from SQLServerCentral.com

There are many methods to do Running Totals and most are either slow to terribly slow or just unreliable. Here’s the right way to do very high speed Running Totals.
More
»