I found an online formatting site wich doesn't require java
They also have a plugin...
Is there any freeware tool to format my sql code in SQL Server Management Studio?
When I try to change filegroup for a clustered primary key on a table without dependencies through SSMS i get
TITLE: Microsoft SQL Server...
After doing some testing on trial versions we go for Red-Gate's SQL Compare.
Seems to be simple and fast and handles most cases incl. partitioned...
Ok, but what if the clustered index is the primary key?
What is the SQL command to move a table to another filegroup?
Do you use alter table for this?
I know I can use something like this
WHERE CONVERT(CHAR(10), date1, 104) = CONVERT(CHAR(10), date1, 104)
wich involves using two...
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...
Ok, thanks that helps.
Any comments on using four disks as I described earlier?
Forgot to say that this is an OLTP system.
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...
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...
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, ..
where x =...
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...
Separate names with a comma.