I am trying to import a tab-delimited text file using SSIS and it is choking on all the numeric fields because they numbers have comma-separators (e.g. 1,000.54). I keep getting t …

Hi, is there a script available that indactes when last a view has been executed. I am currently sitting with 200 views in my database and is not sure if all of them are being used …

I have, as I would imagine all you guys do, a large collection of template scripts that make it easier for me to do certain tasks quickly. I have several hundred but I imagine som …

I recently answered a with question with the code below. My question is, what is the best way to convert a binary [string] to int so I can remove one of the recursive ctes. Eg SELE …

Hi All, Currently I am working as a production DBA but I had engineering background (EE to be specific) and I fell in love with SQL Server and I am now trying to learn SQL Server …

Hi all, I want to fetch the current date or today's date to fetch some data from my database. Now the problem is I want to do this using sql function and since sql function does n …

During DBCC DBREBUILD('DB',' ',90) the following error is always returned on a specific index: “Clustered index 'PK__md_raw_data_poin__2C689DFA' is being rebuilt. Msg 1204, Level …

Can anybody give the guidelines for query optimization techniques as part of performence tuning in SQL server.Does it involves specific tasks to follow?.Thanks in advance..

can anybody provide me cost effective query for my title question,also im not expecting cursors in this context. thanks in advance.

Hi.. I am Developer, good in T-SQL Performance Tuning. but i was allocated to Server Performace Tuning Task and i had a copy of Prod Server as a local Server in my Mechine. I have …

for the same workload and same environment we are implimenting snapshot replication and transactional replication at diffrent locations over produdction servers. Both standby serv …

Seeder question This is a Regular Cursor Declare MyCursor cursor for Select Id, Name From Customer This is a #Cursor Declare #MyCursor cursor for Select Id, Name From Custom …

Since the reversal badge seems a little worthless why not give it away for free, and with 8K helping others out every day, it might as well be you. I will sacrifice this question, …

I have a table with 3 columns ( customer#, line_number, description) what I like to do is to merge all the text for each customer into a new table with two columns (customer#, text …

Can anybody give the best exaplanation for the diffrence between sub-query and nested query?