Viewing 15 posts - 1,036 through 1,050 (of 2,894 total)
Sorry mate, your sample is very obscure to me and I don't have my Crystal Ball with me today to see what you can see on your site.
Your sample doesn't...
October 18, 2012 at 3:59 am
More than happy to help if you follow this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 18, 2012 at 3:10 am
The first thing I would like to advise you when you are gathering statistics in such way is to clean cache before each execution using following command:
DBCC FREEPROCCACHE
Now about...
October 18, 2012 at 3:05 am
can you post the code where you set your CommandText in application?
It is an application issue actually, not SQL one.
Somewhere, instead of stored proc name you use variable with value...
October 17, 2012 at 1:57 pm
shalinder.verma (10/17/2012)
Thanks for all the hard work.
First of all, I was comparing the "on the fly tally table" SQL with "Recursive CTE" SQL. Therefore, my phrase "more efficient" should...
October 17, 2012 at 9:59 am
shalinder.verma (10/17/2012)
Eugene Elutin (10/17/2012)
shalinder.verma (10/17/2012)
October 17, 2012 at 6:11 am
ssurekha2000 (10/17/2012)
checked the sp with jst return stmtalso checked it with simple select stmt without parameters
checkedd connection string
but still when executed frm application gives the same error
Have you checked...
October 17, 2012 at 4:10 am
shalinder.verma (10/17/2012)
If you are familiar with recursive CTE, you can use following SQL. You won't have to refer to any tables. Moreover this is much more efficient. Try it....
Any proves...
October 17, 2012 at 3:41 am
May be the post should read like:
Have I table like a:.... ?
:hehe:
Actually the question is in the post title:
If anyone can help? ...
The answer is: Yes, definitely someone can...
October 16, 2012 at 8:18 am
Yes! Partitioning is exactly what you should use. This exactly feature made SQL Server to be one of RDBMS's for Enterprise Size solutions.
I would start from here:
http://msdn.microsoft.com/en-us/library/ms188232(v=sql.105).aspx
October 16, 2012 at 8:14 am
...
Here's a typical result;
== iTVF calendar function =========
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 3 ms.
===================================
== calendar table =================
SQL Server...
October 16, 2012 at 7:28 am
santoshupadhayay87 (10/16/2012)
sorry everyone i mean the coloumn and not table
That is much much more clear. 😉
Now it's kind of:
Go to somewhere, but not there, and I still don't know where....
October 16, 2012 at 6:54 am
santoshupadhayay87 (10/16/2012)
October 16, 2012 at 5:28 am
There is no in-build "function" to do so, but you can write your own TVF function based on the following:
DECLARE @StartDate DATE = '29 October 2012'
...
October 16, 2012 at 5:20 am
Viewing 15 posts - 1,036 through 1,050 (of 2,894 total)