Viewing 15 posts - 5,566 through 5,580 (of 6,105 total)
Be careful about using a cross join in this manner because if a cross join is specified with a where clause like this, it becomes an inner join. If...
February 25, 2002 at 12:56 pm
quote:
To our surprise, database connectivity drivers proved to be the biggest source of problems.Of the five databases we tested, only Oracle9i...
February 25, 2002 at 11:37 am
Does the client OS support the Arabic language set you are trying to use?
K. Brian Kelley
February 25, 2002 at 11:32 am
Scripts allow for testing in a non-production environment. If the script works in development and QA, it should be fine in production. Scripts also ensure consistent application of...
February 25, 2002 at 11:28 am
Composite keys (when multiple fields make up a unique identifier for a row) are supported in SQL Server. A way to do this in T-SQL is to use a...
February 25, 2002 at 11:22 am
I think JDBC has always been a big issue with SQL Server. I know they are beta testing a new set... don't know how it does on the performance...
February 25, 2002 at 9:31 am
You can execute T-SQL commands through Query Analyzer. Check out Books Online at the BACKUP LOG command.
K. Brian Kelley
February 25, 2002 at 8:44 am
And the only error was the transform failed. Did any changes occur in the database or the file system or what have you with respect to specific permissions? ...
February 25, 2002 at 8:29 am
You can or you cannot do replication to the main server?
Per Microsoft:
quote:
Replication. MSDE 2000 supports merge replication both as a publisher...
February 25, 2002 at 8:26 am
Copied from a direct email:
quote:
No Brian, the agent remains the same. I have 81 packages picking up data from clients running very...
February 25, 2002 at 8:17 am
For managerial level whitepapers and overviews, try:
That'll give you a start.
K. Brian Kelley
February 25, 2002 at 8:14 am
Has the SQL Agent account changed in any way?
K. Brian Kelley
February 25, 2002 at 7:23 am
quote:
Can you call stored procedures from a trigger?
Yes. Think of a trigger as a specialized...
February 24, 2002 at 9:06 pm
You may want to check out the Compaq Active Answers site for some SQL Server sizers.
http://activeanswers.compaq.com
One thing you may want to consider... If you've got a live database taking prescription...
February 23, 2002 at 7:31 pm
There is a basic tool I believe in the SQL 2K Resource Kit for general stress testing, and I know there is one in the BackOffice 4.5 Resource Kit. ...
February 22, 2002 at 12:18 pm
Viewing 15 posts - 5,566 through 5,580 (of 6,105 total)