Frank Kalis

Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 5,356 total)

RE: Restoring Old backup over current data?

You are not putting any pressure on me, are you?
I still think that doing a restore of your log file should yield the desired result or...

December 1, 2003 at 4:38 am

#484094
RE: Restoring Old backup over current data?

The transactions since your last backup should be kept in your log file.
I'm not really sure if I understand you, but I would take a look at Books Online for...

December 1, 2003 at 1:42 am

#484082
RE: Number of replies

Hi Brian,
some time ago I've mailed Andy and Steve two suggestion which have also an import functionality for Snitz. Maybe they'll have kept the mail.
Frank
http://www.insidesql.de
http://www.familienzirkus.de

November 30, 2003 at 12:46 pm

#484061
RE: Table Size

Or set the view is EM to Taskpad
Frank
http://www.insidesql.de
http://www.familienzirkus.de

November 28, 2003 at 1:05 pm

#484027
RE: Table Indexes

To add to the above, this is only true if there is an index on the table at all.
Frank
http://www.insidesql.de
http://www.familienzirkus.de

November 28, 2003 at 1:03 pm

#484026
RE: Table Indexes

What????
Each row in a table is a 'table row'. Unless we don't speak of a clustered index for each row in the table there is also a row in the...

November 28, 2003 at 1:02 pm

#484025
RE: Comments and Bugs on New Design

quote:
Ever though of acting as web design consultant
Btw, the QOD.asp does not seem to have a title tag
Frank
http://www.insidesql.de
http://www.familienzirkus.de

November 28, 2003 at 7:57 am

#484003

RE: delete data/log files when not in use?

You can also modify the file name or even delete it when the database is offline

No matter if services run or not

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Edited by - Frank kalis on 11/28/2003 07:50:52...

November 28, 2003 at 7:50 am

#484002

RE: Comments and Bugs on New Design

Ever though of acting as web design consultant

Btw, the QOD.asp does not seem to have a title tag

Frank

http://www.insidesql.de

http://www.familienzirkus.de

November 28, 2003 at 6:31 am

#483993

RE: Bugs in Enterprise Manager for Numeric?

Doesn't work here either, but do you really need to edit your data via EM?

There are better ways for this

Frank

http://www.insidesql.de

http://www.familienzirkus.de

November 28, 2003 at 5:26 am

#483982

RE: Get better Performance for Querys in SQL

Actually without having the DDL of your query and the table, any advice will be like a shot in the dark.

I assume, you've already tried the index tuning wizard?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

November 28, 2003 at 2:04 am

#483971

RE: Scripts posted by user and and attach fil

I know there is a mod available on Snitz homepage that will let you attach and I think even upload files, but wouldn't this be a security risk?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

November 28, 2003 at 1:25 am

#483966

RE: Page Lock and Objects

The page header contains the ID of the object to which this page belongs.

You can have a play with



dbcc traceon(3604)

go

dbcc page(your values go here)

One of...

November 27, 2003 at 1:27 pm

#483942

RE: Tracking DB grows

Ideas are also in the link I've mentioned included.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

November 27, 2003 at 7:37 am

#483929

RE: Tracking DB grows

Still, little confused.

You mean when the last autogrow occured or when the next one will occur?

If you're looking for the last one, this might help http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12368

Frank

http://www.insidesql.de

http://www.familienzirkus.de

November 27, 2003 at 6:33 am

#483915

Viewing 15 posts - 3,316 through 3,330 (of 5,356 total)