Viewing 15 posts - 19,696 through 19,710 (of 26,490 total)
dba_pkashyap (7/21/2009)
In the view sys.database_files is_growth_percent changes from 0-1, which means...
July 21, 2009 at 10:02 am
A guess:
Database size (in MB) Growth (@ 10%)
100 ...
July 21, 2009 at 10:00 am
bdragoo (7/21/2009)
July 21, 2009 at 9:53 am
Here is a third way to skin a cat:
select
t1.vendorid,
t1.vac1
from
table1 t1
left outer join table2 t2
...
July 21, 2009 at 9:06 am
Tara (7/21/2009)
i still get this errorCannot create index on view . The view contains a convert that is imprecise or non-deterministic.
So change it again:
case when servcdate < CONVERT(datetime, '20040101', 112)...
July 21, 2009 at 8:58 am
Read this article How to Post Performance Problems[/url].
Follow the instructions in it regarding what needs to be posted so that we can provide you with better answers.
Without that information the...
July 21, 2009 at 8:13 am
Personally, I think Lowell has given you what you need to develop a set-based process for copying the records needed from one set of tables to another. I think...
July 21, 2009 at 8:06 am
Yes, you could potentially make the view an indexed view. You really need to read about those in BOL (Books Online, the SQL Server Help System) before going down...
July 21, 2009 at 7:19 am
Now that the Star Trek Universe has been altered, they have opened the door to new series and movies. I wonder how these things will pan out in the...
July 21, 2009 at 7:08 am
Was on a staycation for the week and didn't visit the forums often. Thanks for the feedback. Glad we could be of assistance.
July 20, 2009 at 9:49 pm
Your question is fairly vague. What exactly are you looking for?
July 20, 2009 at 9:29 pm
Why are you shrinking your databases? One, this will cause excessive index fragmentation. Two, the files will simply grow again when the database needs more space that will...
July 20, 2009 at 9:26 pm
Okay, thanks for a partial setup, but please look at how I am presenting my code, including the DDL for the tables, the insert statements with the sample data. ...
July 20, 2009 at 9:15 pm
Viewing 15 posts - 19,696 through 19,710 (of 26,490 total)