RE: How to TEST if statistics should be updated.
We have a small DB 25G. I have found that I get better performance when I update the statistics. so much so, that I now update every night. Curtis Smith Application Dev. Mgr DBA
2003-12-30
SQL in the City
RE: Cursor not working
quote: I believe you are right, but I get equally lost in dealing with all the CASE statements and (so far, anyway) I have found the IF construct in SQL somewhat confusing since there's no requirement for THEN and ENDIF. Any suggestions in that regard--other than just lots of practice and trial-and-error? I guess there […]
2003-12-30
RE: Beta Test New Forums
Doesn't fit to size horizontically? Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-29
1 reads
RE: upgrading from Access to TSQL
Thanks Steve & noeld. Steve - I'll add the table aliases and check out CAST (do you have a good URL for that handy?) Noeld - yes - the app is running now fine in Access, and I will keep this one there. I'm just trying to convert it into tsql to see what changes […]
2003-12-29
1 reads
RE: upgrading from Access to TSQL
The First is that instead of where cnt > 1 Should be deleted and after "group by" just write having count(*)>1 The Second is treaky but, why are you selecting * and the a field that is supposed to be taken from the select statement ? And by the way Your query is formated in […]
2003-12-29
1 reads
RE: upgrading from Access to TSQL
for the first one, you need a table alias, so select a.* from (select....) a where a.cnt > 1 For the 2nd, look up CAST in BOL. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-29
1 reads
RE: Rebuild fk constraints?
Eoin and Greg Thanks for your replies. I actually tried out Gregs script first before I saw Eoin's one. It worked, very well. Eoins script looks very similar. Thank you both. Eamon Edited by - eamonroche on 12/19/2003 03:51:11 AM
2003-12-19
1 reads
RE: Re: SQLAgentmail
Yes. I logged in as the same account. When I sent a test message in SQLagentmail, it didn't go out until I stopped SQLagent service. Thanks
2003-12-18
1 reads
RE: Get better Performance for Querys in SQL
Same as above. We would need the index definitions too to be able to determine if your query uses them correctly Bye Gabor
2003-11-28
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
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