2003-07-03
MDX
RE: Best practice when to use an index
quote: Always, always, always cluster/primary key the ident in a reference table. OK, I have a table with umpteen fields one of which is a date field. The most common query on this table is using ranges of dates. For this reason I put my clustered index on the date column. In another example my […]
2003-06-26
RE: eliminating duplicates from stored procedure joins
There's more... Try the performance if this (remember the execution plan will be saved for this query in proc). SELECT DISTINCT a.* FROM ( SELECT Case30.Case_no#, Case30.Last_name, Case30.[First Name], Case30.Determination, Case30.Sender, Case30.[Case Type], Case30.Date, Case30.[Qwik Due], Case30.[Qwik sent date], Case30.[Final due], Case30.[Final sent date], Case30.[on hold code], tblFileNames.reportid, tblFileNames.type, userviewed.viewid FROM tblFileNames Left Outer Join […]
2003-06-20
RE: New Feature
"so that all the hacks like myself cannot nip into BOL and find the answer." well, that just means you're a cheating loser - sheesh, try answering it using your head.
2003-06-15
RE: Comparing two tables
Please check the syntax and input data of the command. Hope you have full rights.
2003-06-11
1 reads
RE: Read Uncommitted Takes Locks?
No it avoids the locks. However it bypasses locks placed by other items and means you can get dirty data in your results in the process.
2003-06-11
RE: Need help with the logic - New at sql query
Please post the structure of your Invoice table...it will help in determining the sql for your problem... Thanks
2003-06-11
RE: Cumulative wait time on server
Apart from the 1 line BOL and MSDN dedicate to it, I can find very little. I can only assume that if it's high and the server is processing thing acceptably then the high figure is a slow network and/or slow client.
2003-06-10
RE: DBAs versus SQL Server
As others have noted, just listing # of DBA's and # of servers or DB's may be comparing apples to oranges. For instance, here our infrastructure group does all upgrades, patches, etc., not the DBA (me). A lot of my job is data warehouse work. It's hard to give a rule of thumb when the […]
2003-06-06
RE: DTS Security
Try the sp_reassign_dtspackageowner stored procedure in msdb. You must be the current package owner or a member of the sysadmin server role to run it. I haven't had any problems with it.
2003-06-05
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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