Viewing 15 posts - 1 through 15 (of 17 total)
Any thoughts would be deeply appreciated.
For clarity, Would it be beneficial for data buffer caching if we could avoid the adhoc plans from the cache memory in terms of...
December 14, 2010 at 8:53 pm
I am not sure whether still you canmanage from SQL server, howevere, try with os_createmethod(OLEDB programming) using SQL server.
December 14, 2010 at 6:15 pm
Use ODBC programming. Clue: Sp_oacreate
December 13, 2010 at 4:06 am
What about the log file growth and recovery model?
December 12, 2010 at 10:09 pm
I wanna ask a question again as if I could free some space from the cache(by changing the adhoc query plans to prepared compiled, would it be useful for the...
December 12, 2010 at 9:54 pm
Okei, I found the answer as it stores in buffer pool, not in cache.
http://www.sqlteam.com/article/what-data-is-in-sql-server-memory
December 12, 2010 at 9:52 pm
one more note, if the data is being cached means, where is the part in the above been stored?Please help out in the same.
December 12, 2010 at 9:26 pm
Any workaround for the question, now am facing this issue.....
November 10, 2010 at 9:56 am
There are some points to be noted incase you go with moving data to another db:
1. Make the transaction smaller,ie, batches of 10000 where the transaction will be smaller
2. Drop...
November 3, 2009 at 9:32 am
Plz try the same
Declare @RowCount int, @ActualCount int, @StationCode Int
Declare @List Varchar(50), @SplitOn Varchar(1)
Select @RowCount = Count(1) From StationCategoryLink
Set @ActualCount =1
While @RowCount>=@ActualCount
Begin
Select @StationCode = StationCode,@List =CategoryCode From StationCategoryLink...
August 16, 2008 at 4:03 am
Thanks for your reply.Sorry if I took you to a dark as my question is not clear....
There should be only 3 digits before the decimal point and 1 digit after...
July 30, 2008 at 9:20 pm
Check the execution plan for each SP.
Check the SQL profiler to know the period taken to execute the stored proceduress.
Please try to avoid cursors and try to implement set based...
April 15, 2008 at 2:16 am
Linking with Excel
Linked Server:EXCEL_EXPORTER
Provider: Microsoft Jet 4.0 OLEDB Provider
Product Name: Excel
DataSource:
Provider String: Excel 8.0
Note: Check "Distributed Transaction Coordinator" is started in Service.msc.
Select * From EXCEL_EXPORTER...Sheet1$
Insert Into EXCEL_EXPORTER...Sheet1$(F1,Latheesh)
Select 2,'Megh'
April 14, 2008 at 9:45 am
One more major difference is you can never be changed your table design of your table variable if you need in your script once you created. But this is possible...
April 13, 2008 at 11:46 am
Viewing 15 posts - 1 through 15 (of 17 total)