Viewing 15 posts - 1,006 through 1,020 (of 1,315 total)
I read from the holy BOL:
computed_column_expression
Is an expression defining the value of a computed column. A computed column is a virtual column not physically stored in the table....
October 7, 2005 at 8:37 pm
Your post said to create a clustered index on IdentValue and nothing about a ModelID index, but I assume this was an oversight. Obviously it works much better with a...
October 7, 2005 at 7:54 pm
An exact value sometimes allows the query optimizer to come up with a better plan. It knows exactly which rows match, or possibly that there are no matching rows.
With a...
October 7, 2005 at 7:04 pm
Not so fast. If your question is specifically about the order of tables in the ON clause, everyone who expressed a preference said they agreed with your style. So do I. ...
October 7, 2005 at 6:49 pm
I reckon the time it takes the engine to parse a long alias vs a short alias is microscopic. The time it takes you to figure out what a large...
October 7, 2005 at 6:23 pm
The function Sergiy posted would certainly work, but I would worry about performance issues as the invoice table grows. With a clustered index on the identity field, it would have...
October 7, 2005 at 5:53 pm
In addition to the locked bit field and lockeddate datetime field, wouldn't you also need a session id field so you know which web user locked the row?
I might try...
October 7, 2005 at 4:42 pm
This may work, if I understand your question. I think you're looking for a list of views and %tax%sale% (or %sale%tax%) columns that also contain a %sales% column.
October 7, 2005 at 4:03 pm
For performance issues, Query Analyzer's Index Analysis Wizard can evaluate existing indexes and suggest new ones. Put examples of common queries used in this database together in one script, then...
October 7, 2005 at 9:45 am
A cursor-less way to generate all your ALTER DATABASE statements would be:
select
'ALTER DATABASE ' +...
October 7, 2005 at 9:13 am
I read somewhere that if you upgrade your servers to SP4 you have to upgrade the client tools for anyone using EM and QA. I quickly lost interest in it after that,...
October 6, 2005 at 2:06 pm
Starting with the script Casey posted, change the line
SET @SubQueryText='CASE ... END AS [<COLUMN_NAME>]'
to
SET @SubQueryText='MAX(CASE ... END) AS [<COLUMN_NAME>]'
then modify the final EXEC to
EXEC(... + @WhereSQL +...
October 6, 2005 at 1:17 pm
The answer is absolutely not an interactive stored procedure. You could use a DTS or SSIS package with an InputBox in a script task, a web page, a .vbs script with ADO, or many other...
October 5, 2005 at 1:19 pm
I think you may need further modification to get one row per CustomTableRowID.
The subqueries should be something like "MAX(CASE ... END) as [<COLUMN_NAME>]", and add GROUP BY a.CustomTableRowID at the...
October 5, 2005 at 1:07 pm
Viewing 15 posts - 1,006 through 1,020 (of 1,315 total)