Viewing 15 posts - 23,731 through 23,745 (of 26,490 total)
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.
November 17, 2008 at 9:38 am
Can you post the code for your backups?
November 17, 2008 at 9:30 am
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. ...
November 17, 2008 at 9:23 am
aveerabadran (11/17/2008)
November 17, 2008 at 9:11 am
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...
November 17, 2008 at 9:06 am
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...
November 17, 2008 at 9:00 am
clive (11/17/2008)
can someone elaborate on this method of shrinking the log file.
use Mydatabase
go
DECLARE @DB VARCHAR(40)
SELECT @DB = 'Mydatabase'...
November 17, 2008 at 8:56 am
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...
November 16, 2008 at 4:52 pm
ITHELP85 (11/16/2008)
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...
November 16, 2008 at 4:20 pm
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...
November 16, 2008 at 3:58 pm
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...
November 16, 2008 at 3:54 pm
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...
November 15, 2008 at 12:23 pm
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...
November 15, 2008 at 10:35 am
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...
November 15, 2008 at 7:19 am
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))...
November 14, 2008 at 7:59 pm
Viewing 15 posts - 23,731 through 23,745 (of 26,490 total)