RE: cpu utilization
I usually start with RPC:Completed and SQL:BatchCompleted, and get more detailed thereafter only if necessary.
2003-07-01
testing
RE: cpu utilization
Thanks for your replys. I am going to work on it. It has all the issues you have specified. 1. I have 2gb ram, which is not sufficient for this high volume traffic. Every 15 minute transaction dump around 8 to 14mb. 2. I have used profiler to track all sql & stored procedures (is […]
2003-07-01
RE: Trigger on Schema ???
Change to the schema affect the system tables which, unfortunately, cannot have triggers on them. You can schedule a 24-hour trace on the server, looking for statements starting with CREATE, DROP or ALTER. But drawbacks with this approach is that you'll pick up creation of temporary objects too. It's also all too easy for someone […]
2003-06-30
RE: "OTHER" Logic in SQL Server
You could 'build' the hierarchy dynamically in your order by : SELECT TOP 1 answer FROM lookup WHERE (id1='100' or id1='other') AND (id2='100' or id2='other') AND (id3='100' or id3='other') ORDER BY CASE WHEN ID2 = 'OTHER' THEN 3 WHEN ID3= 'OTHER' THEN 2 ELSE 1 END Edited by - NPeeters on 06/30/2003 3:39:35 PM
2003-06-30
RE: Multi Row Insert?
Thanx for the help.... I'm getting a different error.... here it is: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xda0 Thread 0xa90 DBC 0x10a6004 Jet'. I'm using MS Access, here is the connection string..... do I […]
2003-06-27
RE: SQL Server Agent fails to start - no error msg
If you can, try to reboot the machine. Any service pack installed?
2003-06-20
1 reads
2003-06-19
RE: privilege to run bcp
If you're planning to use QA then the user need permission to exec. xp_cmdshell otherwise just the appropriate permissions to write data. for bulk insert: Your user has to be a member of the "Bulk Insert Adminstrators" role which is a server wide role Refer to "Bulk Insert" section "permissions" on BOL MW Edited by […]
2003-06-13
2 reads
RE: Problem Inserting with Multiple Joins
Awesome! That worked! So I didn't even need a join... Thanks a lot man, Joey
2003-06-11
RE: What makes a good developer?
quote: 2. Relentless, to a certain degree. I agree with this. When I started in IT, a friend who was teaching me was like that. I could not, within limits, ask for help. He would guide me and then leave me. When helping others, do you think that is the way to do it? I […]
2003-06-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers