{Copy & Paste your Googled answer here.}...

An automatic rebuild of non-clustered indexes will be initiated whenever there is a change to, creation of, or deletion of, the clustered index on a table that causes a change in the unique row identifiers. There are some slight differences between ...

Collation handles basically two things. First is the order in which rows are sorted. Second is how data elements are compared to each other. The sensitivity of these two aspects are controlled by: - Case Sensitivity:: Does "A" = "a"? - Widt...

My preferred method is... SELECT * FROM TableWithNames WHERE Name LIKE '[A-J]%' My second choice would be... SELECT * FROM TableWithNames WHERE LEFT([Name],1) BETWEEN 'A' AND 'J' These methods are easy to read and maintain. If the TableWi...

Malathi Mahadevan -- "All of it depends on how often this needs to happen. If it is a one time thing it is best for a DBA to do it by hand." We all agree with that. But the original question stated that this is to be done every day....

RE: Manual Intervention You certainly do not want a manual process. The DBA may not be available to manually restrict/grant user access at exactly the times specified every day. Also what happens to the DBA's job when management decides to restri...

Run a query on sys.dm_exec_query_stats. Keeping in mind that sys.dm_exec_query_stats does not store the procedure's name but its ID. You will need to convert the Procedure's name to its ID number to either filter the query ...

The comparison operator error on a filtered index expression is caused whenever an implicit or explicit data conversion occurs on the left side of a comparison operator. The solution is to CAST or CONVERT on the right side of the expression. ...

First -get rid of the CLUSTERED INDEX on the GUID fields. Change to NONCLUSTERED. Second -set the default value for the GUIDs to NEWSEQUENTIALID(). NEWSEQUENTIALID() was introduces in SQL Server 2005 and greatly reduces fragmentation of indexes o...

I would put a trigger on table TEST to check for INSERT, UPDATE, DELETE and issue a ROLLBACK TRANSACTION if action is by user 'A' between the specified times. EXAMPLE:: CREATE TRIGGER dbo.[trgUserTimeRestriction] ON dbo.[Test] ...