2004-03-09
Restore
RE: Some inteligent way of implementing?????
The only issue with implementing using a partitioned view is that you cannot use identity in any of your base tables, so if you have you WILL NOT see a performance improvement. I have seen some of the same problems and a lot can be done by indexing correctly, what you are joining on, and […]
2004-03-03
RE: Returning multiple rows from single row
Thanks for your quick responses.I had imagined the answer to be something like you suggest but I was hoping to avoid temporary tables.I would like to do this in a view if possible becuase it is going to be used as the data source to a report designer.I do not really want to dynamically create […]
2004-03-02
RE: Question of the Day for 02 Mar 2004
I also think the answer quoted is incorrect :-BOL quotes "text in rowWhen OFF or 0 (disabled, the default), it does not change current behavior, and there is no BLOB in row. When specified and @OptionValue is ON (enabled) or an integer value from 24 through 7000, new text, ntext, or image strings are stored […]
2004-03-02
RE: Question of the Day for 02 Mar 2004
The first answer is the correct one. i.e.sp_tableoption N'Employee', 'text in row', '2000'Eventhough the other one with two statements is also correct, it is verbose.Elegant way is the one above.... Thanks..
2004-03-02
Running a job on one server from another server
Please bear with me. I'm new to SQL Server.Using a job defined with Enterprise Manager,I am currently trying to execute an .exe file on one sever from another server. The problem I seem to be having is navigating to the executable file when some of the folders in the path have embedded blanks in the names. […]
2004-02-25
RE: How do you duplicate a record in Stored Procedure
Ben,I would go your route using an audit table. That's what we do where I work. We store the old and new information together in the same record, what form/page the change was made on, date, by who, etc.I would think if you stored the old and new (revised) records in the same table you will eventually […]
2004-02-23
RE: Are partitioned views not that smart?
It could be a bug. Since partitioned views are relatively new, I am not sold that there are not bugs in how they work. We've stayed away becuase of the complexity here and no large tables that would force me to look at those.If you figure somethign out, please post back here, I'd be interested […]
2004-02-13
T-SQL Validation
Needing to write a UDF searching for invalid KEY WORDS in a user defined SQL build. UPDATE and SELECT are the only ones that should be allowed. DROP, TRUNC, INSERT, etc. should not be allowed. Any help is appreciated.
2004-02-12
1 reads
2004-02-10
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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