If anyone here has created a data model for a successful workflow application I'd like to hear about it.

What were some of the considerations you factored into the design?  What...

Are you sure it's fragmentation not the fill factor.

FILLFACTOR specifies a percentage that indicates how full the Database Engine should make the leaf level...

It’s not required if you are not changing their definition (big change).

Try rebuild or reorganize.

ALTER INDEX {...

conSQL -- SQL Server Connection

conAccess -- Access Connection

dtTable -- Filtered Data Table from conSQL

Now, dump dtTable data table via conAccess.

shubham.saxena67 (11/12/2011)

---

Dear Mr. Happy,

As u know that each keyword that is reserved shows with blue color

and LOOP also shows with Blue color within query analyzer..that's why i am

asking..but u do...

In addition to using the Database Mirroring Monitor and dbmmonitor stored procedures to monitor a mirrored...

Can you please post the results of following?

SELECT a.idTest

,a.*

FROM vwMostRecentInstanceOfEachStatusPerTest a

INNER JOIN

...

ha ha :-D... That is what I want to convey. It's not available in SQL Server.

Do you find any LOOP keyword here?

Reserved Keywords (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms189822.aspx

It's time to pay money 😉

667 -- Trial period has expired....

WHILE Boolean_expression

{ sql_statement | statement_block | BREAK | CONTINUE }

WHILE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms178642.aspx

Control-of-Flow Language (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms174290.aspx

There is no FOR loop in SQL Server.

Just to make sure I understand it correctly...

If you have start with Node 8 as Child, it has 2 parents (6&7)

6 has 2 parents -> 2 & 7

7 has 1...

Here is something to start with.

SELECT A.*, B.*

FROM A FULL OUTER JOIN B

ON A.ID = B.ID

WHERE A.ID IS NULL

OR B.ID IS NULL

Or MERGE with OUTPUT clause.

[ WITH <common_table_expression> [,...n]...

It means User Credentials are not supplied by (& saved in) Crystal Reports while connecting it to SQL Server. Check for Crystal Report forums for more.

Or you may use DB Mirroring.

Server1

DB1 – Principal

DB2 – Mirror

Server2

DB1 – Mirror

DB2 - Principal

Database Mirroring Overview

http://msdn.microsoft.com/en-us/library/ms189852.aspx