Hi Andrew, quote: Where does this line of code come from:?id= (SELECT MAX(id) FROM svrmonitor) originally from the keyboard, where I entered this It's a subquery and as such explained in BOL in 'subqueries' Cheers, Frank
2003-07-18
When I try this I get an error: SELECT Regions.Description, COUNT(oh.id) AS TotalOrders, SUM(CASE WHEN (ISNULL(oh.timedorder,0) = 0) THEN 1 ELSE 0 END) AS TotalASAP, SUM(CASE WHEN (oh.timedorder = -1) THEN 1 ELSE 0 END) AS TotalNOASAP, SUM(CASE WHEN (isnull(oh.quote_minutes,0) <=59) AND ISNULL(oh.timedorder,0) THEN 1 ELSE 0 END) AS fiftymins, SUM(CASE WHEN (oh.quote_minutes >= 60 […]
2003-07-17
I have a bunch of DTS packages running nightly from SQL Agent that work fine but I have had problems in the past. Some problems I have had have been: 1. The DTS run command uses the DTS package GUID to find out which DTS package to run. If you make a change to a […]
2003-07-17
quote: Can you share an example of that script and does it run from sql server agent? I have a shutdown script where I shutdown one server about 30 seconds after the second just for the case you've indicated. This ensures the nodes go down gracefully and you don't have the cluster service trying to […]
2003-07-16
Open Enterprise Manager and open the appropriate Database. Go to Management and under Current Activity you can view the current Process ID's. All the best, Dale
2003-07-16
I have a shutdown script where I shutdown one server about 30 seconds after the second just for the case you've indicated. This ensures the nodes go down gracefully and you don't have the cluster service trying to bounce between the two. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance […]
2003-07-14
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-14
Using an approle from Access is just like any other app, you call the proc (setapprole?) and then you're authorized. But that works to let people in, not keep people out. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-14
Are you sure the server is running? This is usually when you have typo'd the name or the server isn't running. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-10
1 reads
There is an index on site_fk in tblline. I tried your query but it displayed the same execution plan as with my query. It uses the site_fk index to find the anumbers, and then does a clustered index scan on the call table. It then creates a hash table and matches them up. I'm pretty […]
2003-07-10
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers