Topics
Started by
Posts
Last post
Hello, Has anyone met this before? It appears to be an undocumented peculiarity when s…
3 replies
SELECT AL2.vch_shortname, AL3.i_event_id, AL1.i_users_id, AL1.vch_lastname,AL1.vch_firstname FROM d…
9 replies
Hi, I reviewed the article by Haidong Ji titled “Using SQL Trace to Audit Database Access” a…
4 replies
We have just installed a Dell 1750 with duel Xeon 3.0, with 4G of memory, running SQL 2000 standard…
12 replies
Hello all gurus of SQL I am running a sp on SQL2000 on Win2k machine with 128 MB ram. In the sp sel…
4 replies
QA testing script below. /* Caution, CREATES TABLE Test64KInsertTemp in current db Seems to me work…
6 replies
So, I figure I'll rebuild indexes based on some criteria such as: AvgPageDensity < 80 OR…
4 replies
I'm trying to "optimize" some code I have, running in CF, where I'd either like to cut the trips to…
5 replies
I Know That Clustered Index Caries The Data At the Leef Level I have A Table With The Following Ind…
4 replies
Hello listers, We are looking for a way to ensure a record is unique. The only way I can think to d…
2 replies
Does anyone know of any citable reference regarding what percentage change in performance users are…
2 replies
I found this as part of a poorly performing stored procedure. I notice with sp_lock that this line …
8 replies
Hi, We're designing a time dimension table for use in datamarts. The hierarchy contains year, month…
7 replies
We connect to sql server using odbc in one of our programs. we do the following query to get field…
4 replies
I'm confused. I'm buying a new datawarehouse server and wanted to max memory but did not want to g…
16 replies
Viewing 15 topics - 1,966 through 1,980 (of 2,581 total)
You must be logged in to create new topics.