thanks Gail..

I will do it and let you know, mean while I try to write a code as below to get the usage of tables.

--Query to Get Dependency of...

Hi Gail Shaw,

thanks for the info, i would to the needful regarding the tables, could you please explain little bit more for SPs..

@anthony.Green, thanks for your suggestion, but...

I just had a guess, you were working on the remote machine, better you try with executing sqlcmd for that particular folder and see whether you are able to access...

Hi,

the link you provided is very useful to know about the DOs and DONTs, and don't mistake me there is one more mistake to be corrected in your article, you...

as I read though this artcile i stuck here..

could you please give me a sample...

1) Ensure the file is not in open state. (in some cases, even though you close that particular file and not the excel, due to cache, you could get this...

Thanks John, Thanks Grant..

I too did what you guys suggested, earlier the table having a clustered Index scan (found from execution plan) to get the key of the particular row,...

No.. the results would be different.. am sure.. (refer the screen shots attached)

may be the CPU usage is not because of only the SQL Query, also some other network...

@halifaxdal

May I know from which DB have you executed this statement, because if its got executed from the system DBs then propably you could get such number of...

It does not make sense, because the CPU...

Thanks to Hardy & Koen for your immediate replies.

@Hardy,

yes it is not a live server as of now, but I am planning to implement the changes to the live server...

yes, ChrisM's query is simple aswell it is more efficient and Optimized too..

--Estimated Subtree Cost = 0.0034222 (to calculate 21.6 rows)

select Field from #tempunpivot UNPIVOT (Field for ColumnName IN ([unic],[nrc],[nr_tel],[id_stud]))...

answer:

if you miss to specify the Index Type, there...

Kenneth Wilhelmsson (11/16/2005)

Whenever I get this message, it's because of one ofthree things:

1) The path/filename is incorrect (check your typing / spelling)

2) The file does not exist. (make sure the...

@sergiy

it returns the current drive and its free spaces, could you guide further, I too facing the same issue

Thanks,

Prabhu