Using IBMDA400 as a provider on SQL 2008 server then a link server object. In the studio when I ask it to create a select statement for a table the numeric columns are not included. I can do Select * and all fields are included and the query works fine or I can simply add the numeric fields to the...

Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by. The computed column is not persisted and there is a non-cluster index on it (the only index on the...

I have two IBM machines with the same exact hardware 32 cores, 256GB RAM for each machine. One machine has Hyperthreading enabled and the other does not. When I run maintenance jobs (dbcc checkdb, and rebuild index) for the database that is 1TB the maintenance job takes 8 hours on the machine that...

Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that...

I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message, "The...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy