Viewing 15 posts - 35,746 through 35,760 (of 39,771 total)
Backing up across the network isn't supported because SQL doesn't have tolerance for slow writes. A file copy will wait and retry, but since SQL is writing quickly, if there...
November 6, 2003 at 9:33 am
See if they can run sp_addlogin (not with EM). This will tell you if they have server level access.
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:31 am
There is some limited information in BOL, but I'm not sure what I can post yet.
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
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
Viewing 15 posts - 35,746 through 35,760 (of 39,771 total)