Viewing 15 posts - 58,876 through 58,890 (of 59,063 total)
If your going to update the table every day, then I'd use non-clustered indexes only.
Another thing to try is to rebuild your data in a staging table that looks exactly...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 4, 2005 at 8:50 pm
Frank wrote: >Could it be you're mixing some kind of presentational stuff in here, Jeff?
Only for demonstration purposes... the pipes were so you could see the spaces.
I'm one of...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 4, 2005 at 8:20 pm
Getting the usage is the hardpart... the names used below are the "logical" names for each file...
SELECT FILEPROPERTY('northwind', 'spaceused')*1024*8
SELECT FILEPROPERTY('northwind_log', 'spaceused')*1024*8To get the allocated file size for each file, use...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 3, 2005 at 9:39 pm
Not a challenge here... I'd really like to know...
Using the following code example, I get what most people would consider to be an "undesirable result"...
CREATE TABLE #MyTest (TestChar CHAR(10)) INSERT...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 3, 2005 at 2:52 pm
Very nice, indeed! It's this type of attention to the forums that makes SQLServerCentral so great.
We all have to remember that a person asking a question has already swallowed...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 3, 2005 at 2:44 pm
It sounds to me that SMALLINT would be the most appropriate here but, if you use INT instead, you will not notice a huge performance change. The big drawback of...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 2, 2005 at 6:05 am
Since you're interested in the DBA side, in the Henderson book, he recommends just letting SQL grow on it's own using only the default settings... very, very bad idea. The...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 31, 2004 at 10:40 pm
I agree with Steve... trap for errors if you are goin to build your own T-SQL to do this. If you use Enterprise Manager to make the table design change,...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 31, 2004 at 10:21 pm
You'd be better off to run the SQL from the view in Query Analyzer once with the Index Wizard to create indexes on the underlying tables of the view.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 30, 2004 at 11:13 pm
>Does this necessarily mean that if I know my application(s) are only going to be used in the US, and won't ever need any other locale, I should save the...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 30, 2004 at 11:08 pm
Perhaps you could have a stored procedure that runs continuously (loop back to start) with a WAIT DELAY '000:00:20'. That would solve the problem of trying to schedule a job...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 30, 2004 at 10:16 pm
Karen,
Bob and I both made the same boo-boo... in the code where the fields get added up, you must include all of that addition in parentheses or you'll get the...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 30, 2004 at 6:05 am
There's many ways to do this but most will involve a loop or a (yeeeeech!) Cursor (Haaaaaack... Patooooooiiiii!), a temp table, or maybe some extra columns added to your existing...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 28, 2004 at 11:17 pm
Beryl,
Borrowing on Kathi's idea, this may run a bit faster because it does no string manipulation or conversion and only has one comparson operator (=). And it could easily be...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 28, 2004 at 10:10 pm
I agree that dependencies related tables are (more or less) unreliable but the SYSOBJECTS and SYSCOMMENTS tables are always up to date with the latest code for any given object. The...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 28, 2004 at 6:39 am
Viewing 15 posts - 58,876 through 58,890 (of 59,063 total)