Programming SQL

Querying ExecutionLog Table
I'm writing a quick and dirty report to give to the powers that be showing just how often - or not - certain reports are run. I'm also going to include some other anecdotal information. One of the things I'd like to include are average times (rendering, data retrieval, etc.). Here's what I've got so far that wo... 15 Jul 2008 17:30

Lookup table structure preferences
Hello, As DBA's, do you have a preference to how code lookup tables are built? For example, say I have the need for a number of lists of selectable values in an application. The first is customer status, the second is salutation, etc etc. As a DBA, do you typically require a separate table for each list typ... 28 Jul 2008 11:02

Problem prefixing object with dbo. when using system stored procedures
The first issue you have to correct is that the qualified name requires single quotes around it. This could fail, but I don't see how it could fail with the "Incorrect syntax near '.'." error. EXEC sp_help 'dbo.myFunction' The [square brackets] are optional if the names follow the standard naming conventions,... 15 Jul 2008 14:23

T-SQL Query Help
I have 2 rather important database updates that I need to make today, and I want to make sure I get the syntax, actually more importantly the update correct! It's query 2 I am more concerned about. Requirements 1. Update 1: Update CustomChar4 in the Outlet table to the value in tTempTable. 2. Update 2: Update... 15 Jul 2008 14:23

ADO Command parameterized queries
For something that Microsoft, and the world, wants me to do, they sure make it difficult to figure out how. i want to use paramaterized queries with a command object against SQL Server. Note: i don't really want to use parameterized queries, i'm just asking a question. Is there a syntax for the replaceme... 18 Jul 2008 08:13

Sql Server 200x Stress Tools?
I currently have Sql Server 2005 Standard Edition. I have a few legacy Sql Server 2000 Standard Edition databases as well. ... I have implemented the Sql Server 2005 Performance Dashboard Reports as well. Those have helped some. ... I am looking for suggestions on tools which can artificially stress... 15 Jul 2008 15:25

Problem prefixing object with dbo. when using system stored procedures
use [mydb] go sp_help dbo.myFunction Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '.'. but the following executes with no problem. use [mydb] go sp_help myFunction I've noticed this problem for a long time with system stored procedures, there must be a reason. Please give me a hin... 16 Jul 2008 17:11

Performance problems after upgrading to 2005 from SQL 7
Hi, The following piece of SQL takes more than 2 minutes in 2005 whereas it takes less than 10 seconds in SQL 7 - --ORIGINAL IF ( SELECT COUNT(*) FROM OrderRecords o JOIN Batches b ON o.BatchID = b.ID JOIN ProcessGateways pg ON o.GatewayID = pg.GatewayID AND pg.ProcessID = @lngProcessID WHERE o... 15 Jul 2008 11:17

Copy Data (attempt 2)
(Apologies if this is a repost, my first hasn't shown up after 4 hours) I'm trying to create a table variable which matches the schema of an existing table with an added 'NewUid' column, and I want to populate it with select data from the live table, and then insert this data back and populate the NewUid colum... 15 Jul 2008 11:17

'sp_send_dbmail'
I need to allow some users to run a script once a month that involves calling 'sp_send_dbmail' to communicate progress. What is the best practice method for giving users access to a system SP like this? I guess I can probably go into each ones server account and do it there? TIA Nigel Ainscoe ... 16 Jul 2008 13:01