1) Indexing, should you find it necessary to index one of the extended fields.

2) Not using the appropriate data type for each column in the table.

Can you post the code for your backups?

First, on the licensing - you can install the Development Edition of MSSQL on a server as long as everyone connecting to it has a developer or MSDN license. ...

aveerabadran (11/17/2008)

---

if i use Send mail task , i need to manually put the smtp server,from & to address , mail subject,etc ..... These info are taken from table and...

As this is posted in a SQL Server 2005 forum, I am going to make a partial assumption, the primary server is running SQL Server 2005. What about the...

I can't really answer your questions either. We are just getting into WSS ourselves. I agree with getting training. I would also look for SharePoint Administration training...

clive (11/17/2008)

---

Found this added as a truncate job on customer SQL Server 2005,

can someone elaborate on this method of shrinking the log file.

use Mydatabase

go

DECLARE @DB VARCHAR(40)

SELECT @DB = 'Mydatabase'...

First of all, if your company has already purchased and deployed SQL Server 2005, they should provide you with the CD's or DVD's used to install SQL Server 2005 on...

ITHELP85 (11/16/2008)

---

WAREHOUSE acts as an inventory.

The Trigger should update the WAREHOUSE.ItemQty column. After testing the trigger I have came up with does not update the WAREHOUSE table correctly the...

You may want to talk to your supervisor or a coworker. You may not store backups on disk for more than 12 hours or so, based on your comment...

I'd start with reading Books Online about restoring the system databases. This is a good place to get basic information. From there, you can ask much more specific...

That looks close to what I have in my calendar view at work. I'll have to check it later, as I am at the Y right now and need...

Jeff,

You still haven't reposted your on-the-fly tally table for SQL Server 2005/2008. I'd be real happy to see that. I use a CTE version in a view (I...

Hey, so would I. I know I could have used a smaller decimal number based on the sample data, but sometimes you you just have to go with something...

Slight change to the code, and this seems to work:

create table #tmp

(id varchar(10))

insert into #tmp

select '10.10'

union all select '1010'

union all select '20.20'

union all select '2020'

select *, cast(cast(id as decimal(18,2))...