Viewing 15 posts - 35,881 through 35,895 (of 39,903 total)
Every connection has read/write according to permissions. It is not based on the connection, but the login.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 9:29 am
You can dig through the dbcc commands and see what's in the procedure cache, but not the database cache.
Perf mon will only give you total server memory.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
November 6, 2003 at 9:28 am
You're welcome and glad it's working.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 9:25 am
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
Viewing 15 posts - 35,881 through 35,895 (of 39,903 total)