Viewing 15 posts - 36,076 through 36,090 (of 49,562 total)
Bob Hovious 24601 (10/29/2009)
.... not to mention practicing martial arts and conquering the galaxy.
Galaxy unfortunately remains unconquered. Haven't touched that game since I mentioned it here. As for martial arts,...
October 29, 2009 at 3:08 pm
CirquedeSQLeil (10/29/2009)
How do you find the time? School, articles, SSC, writing books, work...
School?
It's 11pm and I'm just starting on a report that'll likely take 2-3 hours. Answer your question?;-)
Not...
October 29, 2009 at 3:05 pm
Woot.
Articles finished, slides finished, demos finished. Packing half done (laptop, books, cables and important documents still to do). Just 2 reports to finish and I think one of those is...
October 29, 2009 at 2:57 pm
rudy komacsar - a.k.a. Doctor "X" (10/29/2009)
By upgrading to SP4 you'll be 'supportable by MS until sometime in 2013 !
'supportable' meaning if you have a premier support agreement with MS...
October 29, 2009 at 12:46 pm
Column names and data types you chance with an ALTER TABLE statement. When you say comments, do you mean extended properties?
October 29, 2009 at 11:06 am
CirquedeSQLeil (10/29/2009)
October 29, 2009 at 10:09 am
The column names, column data types, that kind of thing?
October 29, 2009 at 9:26 am
By definition, tables have no order. If you don't specify an ORDER BY, the order that the rows will be returned in is not defined and can change.
Change your SSIS...
October 29, 2009 at 9:12 am
If you're talking about directly updating the actual system tables then no, absolutely not.
The stored procs and related commands that do that are there for a reason. On SQL 2000...
October 29, 2009 at 9:03 am
Please don't shout at us (type all caps)
sp_configure 'Ad Hoc Distributed Queries'
There is a good reason this is disabled by default. Check with the DBA and whoever's responsible for security...
October 29, 2009 at 6:27 am
Sorry, I don't understand. I'm not saying drop the date column.
Define a computed (calculated) column, based on the effective date column then create a unique index on the computed column.
October 29, 2009 at 5:56 am
A restore recreates the database in exactly the same state it was at time of backup.
As for the index usage stats report, that sources off sys.dm_db_index_usage_stats. That DMV is memory...
October 29, 2009 at 5:47 am
Define a computed column as the year and the month, persist that column and stick a unique index on it.
October 29, 2009 at 5:43 am
Viewing 15 posts - 36,076 through 36,090 (of 49,562 total)