MSSQLTips

Hi, Do anyone can confirm me, i am little bit confused whether using alias name will improve the performances Or not? In my point of view, it won't do. Because i observed one thing by the CPU time & elapsed time is less, when i did not use alias name in my query. If it's not Helping to improve...

I have experience with SQL Server 2000 writing queries, creating packages, and procedures. I've been doing the same things in the same way for awhile now, and I feel like there are probably a lot more sophisticated ways of doing things but I can't identify them or figure out how to learn them...

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

what is the diffrence in DBMS and RDBMS?

In SQL 2000 you could use this statement to get the path to a database file SELECT Filename FROM master.dbo.sysdatabases WHERE Name = 'MyDatabase' but this won't return anything in SQL 2005. Any ideas how to retrieve the path to the database from any other SQL queries?? I've seen other...