Viewing 15 posts - 37,651 through 37,665 (of 39,936 total)
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
Not sure how you could do this. Maybe cast the column and see if that removes the collation?
Steve Jones
July 3, 2002 at 10:08 am
If no identity or other colum you could institute a subquery and join
oi.datetime = ( select min( o3.datetime)
...
July 3, 2002 at 10:07 am
Viewing 15 posts - 37,651 through 37,665 (of 39,936 total)