Sorry, I am completely lost from your suggestion. I am asking if anything that can boost up the performance of this situation. There isn't anything...
I have a very simple case and I wanna have some suggestion from guru in this forum. Currently, I am using a SP to build a Live To Date history table....
Can you give me an example ? Or can you specify which extended sp? THank you so much
I would like to know is there anyway that SQL Server can call external assembly function without creating a reference internally. I can do it in SQL...
Thanks Satya, I have read about that before. My concept was that if I have athe proper framework installed in that SQL Server machine, then SQL...
I have installed visual studio 2008 and .net framework 3.5 in my computer. I have then created an assembly in 3.5, but when I try to create assembly...
It is possible. This is the second time I face this problem.
When I restore a database from mdf and ldf file, all the primary key are lost and the data type are not the same. How can I recoever the primary key...
SELECT TOP 1000 dbo.getIPNumber(tracking_IP) FROM tbl_tracking GO It Takes 0 second select countryshort , count(*) from tbl_IPCountry WHERE...
Can someone please help on this Problem?
Here is the thing I ran<br />SET STATISTICS IO ON<br />SET STATISTICS PROFILE ON<br />SET STATISTICS TIME ON<br /><br />select countryshort ,...
yes. I have a cluster on the time. I have another cluster on the fromip and toip, but it does't help on the runtime
1 day. to 1 month. 1 day with 73641 data 1 month with 1965766 data I have also mention in the first post that I only test with the first 10K...
mmarovic, it will be better if you can have more constructive input. date range is up to the report requirement. "need to make sure you have...
The tables struture : IPLookup: FromIP bigInt ToIp bigint Country varchar(20) Tracking table: trackingid int pk TrackingIP bigint...
I tried to make a cluster index on ipfrom and ipto, but it doesn't help. THe index tunning wizard has no suggestion for indexing
I need to create a report on the traffic distribution to our site. It means that I have to find # of people from different country. THe IP Look up...
Can you guys give me more information? How to find it? I know that SQL Server will terminate those thing, however, I need to know what's being...
How can I know when the deadlock occur in SQL Server besides is slowed down or stop running? Anyway to resolve it besides waiting itself to kill the...
oh no. by doing that, I am going to kill my table space. creating and droping table is not an option
Separate names with a comma.
