Viewing 15 posts - 37,531 through 37,545 (of 39,818 total)
Does this table have a different collation? Can you access it from Query Analyzer?
Might be a data issue.
Steve Jones
July 8, 2002 at 10:04 am
No. Easiest way to do this is run Trace and check for activity in that db. Maybe for a month. If nothing appears, then you can archive it.
Steve Jones
July 8, 2002 at 10:03 am
Completely agree with Brian (and thanks).
The GUI does cause slowdowns and issues in deployment. A few references (from my point of view):
http://www.sqlservercentral.com/columnists/sjones/wp_gui.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
Steve Jones
July 8, 2002 at 10:01 am
Or sp_spaceused.
Either will force you to do some calculation.
The full backup is also a good indication of space used. Run one for each filegroup.
Steve Jones
July 8, 2002 at 9:47 am
The only other (easy) way to do this is a bunch of triggers on all tables that insert the data into other tables. There are some tools (I think Lockwood...
July 8, 2002 at 9:46 am
Interesting and thanks. Glad I could summarize it.
I didn't have any bugs, but the warning from Erwin when I changed tables bothered me, so I decided to find out exactly...
July 8, 2002 at 9:42 am
I am always suspect of "I think it works differently"
EM may script different than what you would do, but that does not mean you are doing it wrong.
If you have...
July 3, 2002 at 2:49 pm
Profiler would be a better solution for tracking usage over some time period.
Steve Jones
July 3, 2002 at 2:47 pm
You're welcome and glad it worked.
Steve Jones
July 3, 2002 at 2:45 pm
You'd have to check through them. Somewhere down the line, I suspect that the table is being altered in some way. Is this with a temp table?
Steve Jones
July 3, 2002 at 12:32 pm
Does this happen everytime?
Can you post the table DDL and the stored proc?
Steve Jones
July 3, 2002 at 10:18 am
You need a system datasource. The SQL package runs under the SQLAgent account, which will not see your user DSN.
Steve Jones
July 3, 2002 at 10:17 am
Introduction: State what this is (current config, perform analysis and recommendations)
Current Config: Do hardware and software. SQL config, database physical layout. Server settings, backup plan, etc.
PErformance: Run some numbers, profiler,...
July 3, 2002 at 10:15 am
You'd have to test this. On the surface, I'd say yes, but the time creating the checksum may not outweigh the comparison time. SQL can be pretty fast at comparisons.
Steve...
July 3, 2002 at 10:11 am
The clustered index will eventually be used, either directly or with a bookmark lookup since it contains the data. However the actual choice depends, as Andy says, on the query...
July 3, 2002 at 10:10 am
Viewing 15 posts - 37,531 through 37,545 (of 39,818 total)