Viewing 15 posts - 35,701 through 35,715 (of 39,720 total)
Detailed docs have not been released. I will check the Beta and see and you can always request to get on the Beta.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
November 6, 2003 at 9:23 am
How big are they? I've got 30 on one and run backups sequentially. Do all of them in about 9 minutes using Litespeed.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
November 5, 2003 at 5:56 pm
In addition, you should set memory amounts with multiple instances. The auto management can be too slow to respond to changing conditions.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
November 5, 2003 at 2:07 pm
You could just calculate the value once it's in SQL by finding the row just before it (in terms of date) like this:
select
a.currency
, a.currdate...
November 5, 2003 at 12:41 pm
Unless you can trigger something to run, then it would be hard. You could setup a process (job) to run every minute and look for entries in sysprocesses and compare...
November 5, 2003 at 9:19 am
You'd have to dig through BOL, but I think 8kb sounds right. I thought it was substantially enhanced in SQL 7.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 5, 2003 at 9:18 am
SELECT top 1 with ties
PRODUCTID, SUM(Quantity*UnitPrice)
FROM [ORDER DETAILS]
GROUP BY PRODUCTID
order by SUM(Quantity*UnitPrice) desc
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 4, 2003 at 1:21 pm
Is it worth it? Why not jsut handle those as a one off?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 4, 2003 at 1:15 pm
You can specify a specific login for non sysadmins that xp_cmdshell will use.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 4, 2003 at 1:10 pm
Is this on all Dbs or only system dbs?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 2, 2003 at 10:18 pm
My only add to this is the "supposedly" the query optimizer "likes" clustered indexes. Not really sure how to test this, but the recommendation is always to have a clustered...
November 2, 2003 at 10:17 pm
when 'x' then 'a =''' + @a + ''''
assumign @a is a char.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 2, 2003 at 10:16 pm
run a profiler trace.
Access can at times really hinder performance because it asks for a bunch of data from SS.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 2, 2003 at 10:15 pm
KISS it. I vote for tejeshc's solution.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 2, 2003 at 10:14 pm
Compilation can be a substantial portion of the execution time, but 2-3 minutes seems excessive, even for something as complicated as you have here.
given that, you might consider working on...
November 2, 2003 at 3:50 pm
Viewing 15 posts - 35,701 through 35,715 (of 39,720 total)