Viewing 15 posts - 2,536 through 2,550 (of 3,232 total)
Are you saying that your want to put the transaction logs on the same mirrored set of disks with the OS? Where is your paging file?
The ideal situation would be seperate...
November 16, 2006 at 3:38 pm
How are you scheduling it, SQL Agent? Who is the job owner? Which account is your SQL Agent running under? How were you logged in when you ran it manually?
November 16, 2006 at 3:11 pm
Ken's example does just that. Why don't you follow Remi's advice and post some sample data and your expected output?
November 16, 2006 at 1:43 pm
You're going down the right path, but try using decimal data type and setting the precision and scale. For example,
declare @money money
set @money = 150.2315
select CAST(@money as decimal(18,2))
November 16, 2006 at 11:53 am
Your error is comming from your UNION statement. Look up UNION versus UNION ALL in BOL. UNION is pretty much the same as doing a DISTINCT on the UNIONed recordset...
November 16, 2006 at 11:46 am
I would step through your code and find out what the value of @sHMC and @iRowCounter are right before the error. I think you'll find that the value already exists. ...
November 15, 2006 at 8:24 am
Can you post your table DDL (including indexes) for the Person table? Also, are you starting with an empty table? The only way to get this error is if the...
November 14, 2006 at 4:20 pm
The row already exists in the index PersonUserName. Whether or not you've ran a previous INSERT, the row already exists. That is the only way to produce this message! It...
November 14, 2006 at 4:04 pm
When you look at your DTS package in the designer window, you should see arrows between tasks/connections. These arrows show you the order of operations for your package. Add in...
November 14, 2006 at 10:03 am
N'A01' tells SQL Server to treat the contents of the string, in this case A01, as Unicode. If you look at the sysusers.name column, it is of data type SysName. ...
November 14, 2006 at 9:49 am
You can use an INSERT INTO #tmpTable(col1, col2, etc) SELECT EXEC sp_stored_procedure @parameter1, @parameter2, @etc
There are some pros/cons you may want to know regarding this approach that I do not have...
November 7, 2006 at 4:44 pm
Based on the code you've posted, it is unclear as to exactly what you are trying to accomplish. What are you doing with the results from the SELECT? Is there...
November 7, 2006 at 10:10 am
Thanks for the example Jeff.
Faizjmc, it is important to note that Jeff set the ROWCOUNT back to zero after he was finished. Don't forget to do this! Forgetting to...
November 6, 2006 at 8:49 am
Thanks for the detail Colin. Yes, it makes loads of sense. I am aware of the differences in read/write performance between RAID levels, but I guess that part that got me...
November 6, 2006 at 8:46 am
Viewing 15 posts - 2,536 through 2,550 (of 3,232 total)