Having 2TB OLTP database look strange, but it is reality, one of our customer database having 2 years of data. And because of large data size the...
We have 4-5 tables and those are having around 15-20 indexes few of them may be not in use, but don't know how to find out those. Is there any way...
We are doing field level auditing on company table. If the field value is updated then we are inserting new row into CompanyTrack table with their...
Let me know if you have experienced any performance/other problems while accepting the text field as input parameter in stored procedure. I have to...
Select a.contactid, a.companyid, ................, a.city, CompanyActive = (Select c.Active From company c Where c.CompanyID = a.CompanyID), Case...
One of our SP is timing out on the testing server but it is working fine on the main production server. I checked table structurs & indexes related...
User Northwind select top 5 * from customers where city = 'London' Union select top 5 * from customers where city = 'Sao Paulo' order by city desc...
Brad,<br />Is there any relation between sqlteam.com and sql-server-performacne.com?<br />Because the user interface for forum is almost same [<img...
I want to use WAITFOR to execute one of our sp. Before that I would like to know the experience of all forum GURU's. Whether it is reliable?...
Is there any way to recover the table, which is got deleted? Surendra Kalekar
I am not able to edit/create SQL Server registration in EM by using sa user. It thows me the below error. -----------------------------------------...
Our company table is having more than 45 fields like companyid, comapnyname, address1, address2, pobox, city, state, country etc.. etc.. We want to...
Can we update Text field through triggers? Surendra Kalekar
What is the best way in stored procedure to fetch output rows into CSV format? We are having almost all the major data types in the results plus we...
Whether it is possible to import/export diagrams from one database to another. Both databases are same. Surendra Kalekar
The below function is used to remove the unwanted ASCII characters from the given string. This function works very slow because it checks character...
How to write the SQL Statement to find out a particular column is IDENTITY column or not? If yes what is the IDENTITY Seed and IDENTITY increment...
In Enterprise Manager after selecting a particular database...... when we click on any objects like table, views etc. either it is taking too much...
Declare @companyids varchar(1000) select @companyids = '17068,72947,17069,56650' Declare @Str1 varchar(1000) Select @str1 = 'select companyid,...
Hi I created a schedule in DTS for 30 min Do you i need to execute immedietly? If I wait for 30 min it doesn't reflect any rows.If i execute it...
Separate names with a comma.
