For datetime you better use convert instead of cast becasue for convert you can specify the format of your character data. See BOL for convert and there the style parameter

No, they are not. This is mainly due to the internal way...

For performance reasons even I would put those files to the filesystem and store just the path but if security it the main objectiv then you can store the images...

But Jeff,

Even if he creates a weekly maintenance plan it wouldn't defragment his table if there is no index on and if the table lis smaller the 8 pages (as...

There will be an issue if you are referring to the server by its IP address instead of its name.

In this case you will have to manually (or by any...

put your DB to bulk logged mode instead of simple. This will reduce the number of entries into the log

What you want is basically a pivot table or cross table.

In SS2005 you have it automatically, otherwise have a look on this forum a search for those keywords like pivot,...

As far as I know you cannot refer in a where clause to a column number.

But you can do this in the order by clause:

ie:

select SomeFields from MyTable where 1='SomeValue'

would...

Just simply replace the WHILE clause by IF

Then it works:

create proc ShowHierarchy

@ParentID int,

@Placement int

as

begin

set nocount on

select @Placement = min(Placement)

from ParticleCMS_Particles

where ParentID = @ParentID and...

You should not use XML for this.

A simple BCP out to a TAB (or what ever) delimited file, then BCP in is the best and most efficient way. Instead of...

Make your table as narrow as possible to be able to fit as many records as possible within one page. And use clustered index.

Load your text file into Excel, or BCP in into an another table

And as a general remark: As long as you have functions (replace, substring...) in your WHERE or ON clauses the optimiser would never use any indexes.

But why are you using any group by clause if you do not have any aggregat (SUM, COUNT, AVG...) function?

And why are you using the embedded select statement where a...

And if you don't want to play with system tables then just run the sp_spaceused YourTable system stored proc to get an approximative count. if you run dbcc updateusage before...