Viewing 15 posts - 511 through 525 (of 1,131 total)
For error handling, please be sure to read Erland Sommarskog's article at
http://www.sommarskog.se/error-handling-I.html
Based on the article and all of the conditions where error handling cannot be performed, I recommend having all...
SQL = Scarcely Qualifies as a Language
April 29, 2008 at 5:51 pm
Also suggest reviewing this join condition as derived columns cannot use an index.
Original:
on mll.conta+mll.u_subconta = ml.conta+ml.u_subconta
Suggested:
on mll.conta = ml.conta
and mll.u_subconta = ml.u_subconta
SQL = Scarcely Qualifies as a Language
April 29, 2008 at 6:00 am
Under SQL Server 2005, the add_server_role_member and drop_server_role_member may only be used with event notification and cannot be used with DDL Triggers. The reasoning is that since only a...
SQL = Scarcely Qualifies as a Language
April 27, 2008 at 9:00 am
Your problem is not clear as "no luck" is not very meaningful. Do you mean that no rows are found ? If so, check the value of the...
SQL = Scarcely Qualifies as a Language
April 27, 2008 at 7:50 am
select @Nm = 'Age'
select @Null = count(*) from #t1 where (@Nm) is null
As "where (@Nm) is null" will always be false, zero rows will meet the
restriction.
Why are you...
SQL = Scarcely Qualifies as a Language
April 23, 2008 at 7:51 am
An internet search found the below at http://www.expertsforge.com/Applications/Tutorial-133.asp
Reason for the Error:
NotesSQL expects to find Notes.ini in the \Lotus\Notes directory. If the file is not in this directory, the driver may...
SQL = Scarcely Qualifies as a Language
April 15, 2008 at 10:24 am
Under SQL Server 2005, you can grant permissions on a schema, such as
GRANT SELECT ON SCHEMA :: dbo to Reader
SQL = Scarcely Qualifies as a Language
April 8, 2008 at 5:16 pm
"This is the site for the software: http://manageengine.adventnet.com/products/eventlog/
I have since been informed by my manager that there is a version for MS SQL Server.
"
Great -
You should be very...
SQL = Scarcely Qualifies as a Language
April 2, 2008 at 10:53 am
Yes, it is a bad idea as SQL Server will have performance and stability problems if there are any other services that use significant resources.
Optimal is to have...
SQL = Scarcely Qualifies as a Language
April 2, 2008 at 9:08 am
Be careful about applying Northern Europe name capitialization rules to names of persons from other cultures. For example, notice the capitalization and accents for:
Gustavo Nery de Sá da Silva
José...
SQL = Scarcely Qualifies as a Language
March 28, 2008 at 11:17 am
Recommend this as a necessity:
The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data Models by Michael Reingruber, William W. Gregory (Contributor)
Publisher: John Wiley & Sons; ISBN: 0471052906;...
SQL = Scarcely Qualifies as a Language
March 27, 2008 at 12:27 pm
Instead of a JOIN, using a UNION contruct is easier and will run faster. Note that the constants for from/to are set to 0 or 1 appropriately.
SELECTStateCode
,SUM(StateFromCnt) AS StateFromCnt
,SUM(StateToCnt)...
SQL = Scarcely Qualifies as a Language
March 1, 2008 at 10:43 am
"Is there some way to ensure that the INSERT statement is committed and only the statements in the trigger are rolled back?"
It depends on the statement in the trigger:
1. ...
SQL = Scarcely Qualifies as a Language
February 22, 2008 at 11:55 am
"there's not mention of an instance name in that path."
Please read my post carefully - "for a default instance" is what I wrote, meaning that a named instance will have...
SQL = Scarcely Qualifies as a Language
February 21, 2008 at 5:42 am
"Is the SAN replication configured as an incremental snapshot or a complete copy?"
Neither - SAN Replication is configured as synchronous meaning that all writes on the production SAN partition are...
SQL = Scarcely Qualifies as a Language
February 21, 2008 at 5:30 am
Viewing 15 posts - 511 through 525 (of 1,131 total)