Which index will will Act First

All this depends on how huge your data is going to come every day and how you are going to maintain.Lowell has given a approximate or near by value.Keeping a...

select * into tablename FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')

Have...

Estimating the Size of a Database

http://msdn.microsoft.com/en-us/library/ms187445.aspx

Estimating the Size of a Table

http://msdn.microsoft.com/en-us/library/ms175991.aspx

Hi,

This is what you are looking for

go

declare @Temp table(name varchar(50),Snum varchar(50) )

insert @Temp values

('bill' , 1),

('bill' , 2),

('tom' , 3),

('tom' ,20),

('john' , 6)

SELECT DISTINCT name,SUBSTRING((SELECT...

Hi ,

Have look on this

CREATE TABLE #MyTable (My int)

CREATE TABLE #MyTable1 (My int)

CREATE TABLE #MyTable2 (My int)

INSERT INTO #MyTable

SELECT 65 UNION ALL

SELECT 54 UNION ALL

SELECT 46

INSERT INTO #MyTable1

SELECT 46...

Hi,

There might be other easy solutions also.

/*Your data in to this table*/

declare @Temp table ([Customer_Name] varchar(50),[Financial_Year] varchar(25), [No_of_Years] int,[Total_Value] int)

insert @Temp values ('Customer A', '2010/11' ,3, 30000)

insert @Temp values...

Hi,

Some of the Tables and Views you need to check are

Select * from msdb..sysjobhistory

Select * from msdb..sysjobs

Select * from msdb..sysjobservers

Select * from msdb..sysjobs_view

Select * from msdb..sysjobactivity

Select * from msdb..sysjobsteps

Select *...

Hi,

I think you may do in this way

declare @Email table (id int identity(1,1),email varchar(75),status bit)

insert into @Email

values

('Email1@Email.com',1),

('Email2@Email.com',0),

('Email3@Email.com',0),

('Email4@Email.com',1),

('Email5@Email.com',0),

('Email6@Email.com',1)

Select * from @Email where status=0 /*0- Acive 1-In-Active*/

declare...

Hi

Try this

Select * from sys.sysobjects where xtype='v' and id in(

Select id from sys.syscomments where text like '%where empid=%')

instead of V you can put P also to derive SP's...

I think you have missunderstand what i have asked.I asked him why you need to avoid...

First off all Why? you need to avoid...

You have to use :

SET XACT_ABORT ON/OFF

opition to Distributed Queries from one server to another server.

Have a look on Distributed Queries and Distributed Transactions so that you will be getting...

Sturev (4/2/2011)

---

I have a need to pull a date column from one table based on the date in another.

Example:

I have a service table that contains details about a service appointment

Then...