Ha ha ha...

You got me... But here the time has past noon now 🙂

Dynamic query is a banned concept in my company.

1. Monitoring performance is hard

2. Security concerns

3. Debugging is difficult.

Coloumn per language is too costly. Each time a language is adopted, we need to change the schema of all tables

I am thinking on moving the sorting to application

Other...

Hi all,

Thank you for your response.

I can identify the data with the collation. But my coding is going to be complex.

PLease check the code

Use tempdb;

Create Table CollateTest

(

LineiD...

But then, how will you add sorting to the select query?

This script does not consider the row overhead involved over variable columns, nullable columns and bit columns. I believe ( not tested though) about calculated columns were also not...

Hi,

Thank you for the note, sorry for the late response.

Actually the code was first written in 2002 and I modified in 2004. I can't remember touching this code...

If you want the same rights over all databases, you can also use sp_msForEachDB stored procedure. But if your need is different from database to database, you need to...

I recently gave a presentation on table aprtitioning at Sri Lankan user group meeting. Please check the site:

http://sqlserveruniverse.com/content/MeetingList.aspx

Let me clarify one point:

You can have the...

Primary key should be Unique, but need not to be Clustered.

Clustered index need not to be Unique

Preethiviraj Kulasingham (2/25/2008)

---

I suggest that you should explore one of the two solutions (but not both):

1. Create the primary Key as NON CLUSTERED

2. Think about partitioning the table...

Hi Sara,

A Couple of points:

1. As the actual data pages should be based on clustered index, you can't have the clustered index on one column and partition on...

Are you missing the Join condition?

In your query, all columns in the SELECT clause belong to BillingRecord table.

You are using the package type table but it is not JOINed with...

You can minimize the administrative work by using Roles.

Create a Role and Give all the permissions to that role. Add the users to that role.

Either you can give Execute,...

Hi,

Read Commited is the default isolation of the database.

can you Identify all the rows and update tem in small chuncks so that the locks will not be at the...