Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These 'code smells' are coding styles that, while not bugs, suggest design problems with the code. In this PDF, Phil Factor's put together 119 of those code smells so you can see what to avoid and why.
2014-09-25
12,476 reads
Today we have a guest editorial from Brad Wallace that is an attempt to answer the question 'Why is database engineering so expensive?'
2011-08-18
471 reads
You pretty much said it yourself. The user needs to have direct access to the table if you make the select in dynamic sql. Try this to solve your problem : Declare @maxrows as int set @maxrows = 10 Set rowcount @maxrows select * from dbo.SysObjects order by name set rowcount 0 This will allow […]
2005-03-24
If your question is: "Is it better to have a single table with the capacity for multiple addresses in a single row, or one master table linked to an address table?", basic database theory would tell you to create a separate address table and this is what I would recommend. This is how relational databases […]
2004-11-21
Yes.Every time after error message, I reboot the server computer, after that when I test it from the operator's property, it displays a message tellig that the message has been sent successfully. but the message are not sent.
2004-05-17
Tnx, this sounds promising and I am going to give it a try. Cuurently I am struggling with another problem, related to this 1: see http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=114219If you have an answer to that 1, I owe you.
2004-05-04
Lorna, You need to supply a maximum VARCHAR length in your CAST (same with CONVERT) function, or the max will be set at 30. Compare: select cast(replicate('1234567890', 20) AS VARCHAR) with select cast(replicate('1234567890', 20) AS VARCHAR(255)) Cheers, - Mark
2003-08-14
The trick here is in excluding all people with any record where note_type_fk = 29. Your current query will return people with note_type_fk = 29 if they also have a record with a different note_type_fk. Analyzing a query of this complexity is not simple without the actual data behind it, but you can try this […]
2003-07-31
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers