Forum Replies Created
Viewing 15 posts - 6,316 through 6,330 (of 7,489 total)
-
RE: Difference between table1, table2 and table1 inner join table2
IMO the JOIN-syntax using the on clause differantiates better wat's a join-predicate (on-clause) and what's a filter-predicate (where clause).
This makes is more ease for another person to understand your queries.
Check this...
-
RE: Table Variable with Identity Column
check books online
DBCC CHECKIDENT ('table_name', NORESEED) just for reporting
or
DBCC CHECKIDENT ('table_name', RESEED) reporting and correction !
What error is checkident giving ?
-
RE: SQL Performance
do you have scheduled jobs for DBCC DBReindex ?
or indexdefrag ?
If not, reorganize the data and test again.
Maybe it's time to do this on a scheduled/planned basis.
-
RE: SQL Performance
We also have a couple of applications running on citrix for the front-end applications, with sql2000 on an dedicated SQL-cluster-node (running only that instance).
Most of the times when users are...
-
RE: Printing in .NET
Do you know of a simple way of making a screen-shot (winforms) with .Net code, using the framework (not extra referring to the gdi32.dll ) ?
-
RE: Migration plan SQL2k to SQL2K5
Check out the upgrade-advisor !
It will check your current db, .. and highlite some issues (if found
) -
RE: How delete the rows where comlete record is null.
the BINARY_CHECKSUM and checksum solution is great, but know their downsides (text/image/...)
It's all in Bol
-
RE: Moving user databases...
So for the sqlserver-instance it's an existing db which will be detatched and reattatched, only having the files at a diffent location.
In that case, the sync is not needed.
What the...
-
RE: Moving user databases...
yep.
don't forget users and passwords and their synchronisation
-
RE: Application Security
it depends
If you want to create the possibility for you users that they access you sqlserver using only your application, or also...
-
RE: A little help on Alerts
The mentioned URL should contain this :
-- The goal is to avoid the use of sp_start_job in an application. So we have the application use RAISERROR to activate the job.
-- ...
-
RE: Table Sizing
you may also want to run sp_updatestats ! (if you are alowed to)
Did you rebuild your clustering index ?
-
RE: Collation Codes
yep. Keep it simple.
If you have DRI (foreign keys), you may want to hold them until after the load !
Or you will have the burdon of a loadsequence exercise.
Test it,...
-
RE: Table Sizing
can you post your table and index DDL ?
-
RE: Collation Codes
Since the old server is the onlyone having SQL_Latin1_General_CP1_CI_AS , and the others use Latin1_general_CI_AS , maybe this is _the_ occasion to migrate !
This way, when all servers...
Viewing 15 posts - 6,316 through 6,330 (of 7,489 total)