Viewing 15 posts - 32,311 through 32,325 (of 49,552 total)
Duncan Pryde (6/22/2010)
I'm almost completely sure that replication has never been set up on the database, and can't see any evidence that it has, but how could I check definitively?
If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 2:32 am
Is this an academic question, or do you have town pages in your DB?
If it's an academic question, options are restore from a clean backup or run checkDB with the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 2:07 am
I don't believe that SQL keeps history of file sizes. So you'll have to write something that checks and logs the files sizes every day. Once you have that, it'll...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 1:52 am
You'll need date inserted column or identity on each table. A column that shows when a row was inserted.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 1:47 am
Please post query, table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 1:44 am
shield_21 (6/22/2010)
The result is also sorted by V1 and V2 in ascending order since that is the order when you inserted those records into @AAAATABLE..
Order that rows were inserted...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 1:42 am
Then you need a full backup from before the 1 May, and log backups up to the point that you want to recover from.
You can never restore to a point...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 1:41 am
nguyennd (6/22/2010)
But in this case, my flow use insert into select with order by (K is IDENTITY). How many percent the result cannot order V1,V2?
The order inserted is irrelevant. If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2010 at 1:40 am
If there's lots of small transactions, the log buffer size is not going to be a contributing factor. Log records must be flushed to disk when the transaction completes, regardless...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2010 at 11:51 pm
gorkchow (6/21/2010)
is it ok with mssql to indicate all combinations and specify only those which are used?..
It's fine to declare and pass parameters to sp_executesql that are never used.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2010 at 11:50 pm
Steve Cullen (6/21/2010)
It really doesn't matter what in order you load the table, you order it on the select out, or use a clustered index.
There's no OR here. If you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2010 at 11:49 pm
If you want to restore to the 1st May, you need a backup from the 1st May. Since the DB is in simple, you need a backup from the date...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2010 at 11:46 pm
By manually do you mean:
using an insert statement across the linked server?
using an insert connected directly to the server that contains the table?
something else?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2010 at 2:55 pm
Give them view definition rights on either the object or the schema.
GRANT VIEW DEFINITION ON schema::<schema name> TO <user>
I think that's the syntax...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2010 at 9:55 am
I think this is what you need. Not 100% sure. Long time since I tried to debug these things myself. You'll also need the public symbols for SQL, tool should...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2010 at 8:56 am
Viewing 15 posts - 32,311 through 32,325 (of 49,552 total)