Search Results | SQL Server Performance Forums

Formatting SQL

Thread by: viteb, Mar 21, 2007, 4 replies, in forum: Third Party Tools

Is there any freeware tool to format my sql code in SQL Server Management Studio? Thanks,EB

Move a table to other filegroup

Thread by: viteb, Mar 14, 2007, 6 replies, in forum: SQL Server 2005 General DBA Questions

What is the SQL command to move a table to another filegroup? Do you use alter table for this? Thanks,EB

Date without time

Thread by: viteb, Mar 5, 2007, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi. Simple question (SQL Server 2005): Is it possible to make a user-defined data type derived from datetime that does not store the timepart? If...

Physical architecture

Thread by: viteb, Feb 26, 2007, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi. Today i'm running Ms SQL Server 2005 where logs are located on one physical disk and the five data-files on a second disk. As the db has grown...

Synchronizing schemas

Thread by: viteb, Feb 26, 2007, 4 replies, in forum: Third Party Tools

Hi. I want a tool to help moving database changes from dev to test and then to prod. It must support MS SQL Server 2005 and handle rollback in case...

Different execution plan

Thread by: viteb, Feb 21, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi. I'm running SQL Server 2005 and I'm quite new on this platform. I have a query with a subquery on the form select a, b, .. from tab where x =...

Too many indexes

Thread by: viteb, Feb 19, 2007, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi. I'm quite new to MS SQL Server 2005. We have a table in production that has a few indexes. I suspect that not all of the indexes are used and...