Viewing 15 posts - 6,706 through 6,720 (of 7,429 total)
Have to run DBCC CHECKDB to see if anything is found wrong with the database itself? Or DBCC CHECKTABLE? Could be a problem with the allocations for the table internal...
March 22, 2002 at 5:05 am
quote:
I want to know, if there was a performance issue(for example) who would be guilty: developers or hardware.
March 22, 2002 at 5:02 am
Same as attach.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 22, 2002 at 4:55 am
hirepwrd as for having a PK instead of unique clustered index alone the only extra bennifit you get is that only a PK can be the FK constraint for another...
March 22, 2002 at 4:53 am
Sorry there is no direct way to know when table was last touched unless you have a audit system built for inserts, updates, deletes, or even selects (but those...
March 22, 2002 at 4:48 am
Well with storing the data in SQL you potentially cause a lot of overhead in various areas and could lock periodically causing user frustration. I would look into a xml...
March 21, 2002 at 10:36 am
I do not believe that anything happens to the database as SQL 2000 is capable of readin 7 databases without issue.
"Don't roll your eyes at me. I will tape them...
March 21, 2002 at 10:29 am
Ooh, I like, except with the objectname since you could potentially have two or more tables with same column name, just make sure you will be able to id which...
March 21, 2002 at 10:24 am
At the database level itself no, at the database server then you will only see performance gains. This is ideal situation in that you are programming with less resources and...
March 21, 2002 at 10:20 am
I enjoyed the challenge.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 21, 2002 at 10:13 am
I agree with Andy, just do basically what Microsoft did in SQL 2000 and create a comments table with an id field that you store the object id of the...
March 21, 2002 at 9:16 am
I agree, that is why I stated static tables (usually configuration or set parameteres that noone shoul have access to directly edit other than an admin), but you could without...
March 21, 2002 at 8:58 am
Sorry did find the mistake as I set the value to the last day of the previous month and like Feb = 28 will then rolles 3/28 for march...
March 21, 2002 at 8:51 am
No because you will name it.
EXEC sp_attach_db
@dbname = N'yourdbnamehere',
@filename1 = N'drive:\path\file.mdf',
@filename2 = N'drive:\path\file.ldf'
"Don't roll your eyes at me. I will tape...
March 21, 2002 at 7:28 am
When I do this I always get a warning. Are you using straight sql in you proc or dynamic which it cannot see until execution?
"Don't roll your eyes at me....
March 21, 2002 at 6:10 am
Viewing 15 posts - 6,706 through 6,720 (of 7,429 total)