Forum Replies Created
Viewing 15 posts - 46 through 60 (of 71 total)
-
RE: T-SQL Code Bank
I too like EditPlus but I do my SQL code editing in SQL Server Management Studio. I add my code snippets to the Template Explorer. It has a...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Half a Million
I find either an interesting article or post every day in SSC. SSC is one of my major learning tools for SQL server. I have gotten many ideas...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Efficencies of ORDER BY
If you believe Joe Celko the use of positional column numbers has been deprecated in standard sql:
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Create Trigger on Conditional Logic
We conditionally bypass triggers for some batch processes on the production database. We don't bypass triggers in the application.
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Create Trigger on Conditional Logic
Why don't you DISABLE/ENABLE the trigger instead of dropping it:
The trigger still exists but will not fire!
/** Only disable if client A **/
if exists (select * from dbo.sysobjects where id...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: empty DB columns are not ''''NOT NULL'''' so search for not null fails
Jeff,
Thanks for the insight on Index usage and formulas in where clauses. I guess I know better than to use SELECT * in production code.
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: empty DB columns are not ''''NOT NULL'''' so search for not null fails
Hi,
We have the same issue. Notice that
SELECT * FROM blackhole WHERE DATALENGTH(singularity)>0
will give you the same result since DATALENGTH(NULL) is not greater than 0
If you also want to eliminate...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: SELECT dependant on parameter value
SELECT * FROM myTable
WHERE customerID = CASE
WHEN @customerID = myValue THEN myValue
ELSE customerID
END
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: user_name() vs system_user - why does one not return the correct name?
Use suser_sname(). This should return the correct name. I believe that the name returned by user_name() changed between SQL 6.5 and SQL7. BOL tells you that user_name() returns dbo for someone...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Timestamp
Be aware that the Timestamp data type has been deprecated. In SQL 2000 and 2005 it has been aliased by ROWVERSION, a more descriptive name. I would recommend adding a...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Need script to split a column fullname to first & last name
I've got one of those "non-hyphenated double-barreled surnames". It sure is an inconveniance when I get misfiled because the database only recognized the word after the last space as...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Job Schedule
Nope - no Stat Holidays in the U.S. or Canada for ends of any months
Holidays can vary by city and state and year:
Memorial Day (US) can fall on May 31...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Notification on update
Sending mail from a trigger is not recommended. Triggers should be performed quickly since other things wait for completion of the trigger. Sending mail is slow and frought with problems. One...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Why use triggers?
Every table I have has a trigger on Update to track changes made to the record at the database level. All tables have fields of "UpdatedBy" and "UpdateTime" which are...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.] -
RE: Parse
It's a bad table design to put 2 values (first and last name) in a single field. In my part of the country there are many 2 word last names...
TerriTo speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.]
Viewing 15 posts - 46 through 60 (of 71 total)