Viewing 15 posts - 301 through 315 (of 322 total)
Hi SQL Noob,
In a previous post, you said it was buggy...
Does that mean that you are happy to buy a buggy database backup software :crying: or that it's not buggy...
February 1, 2008 at 9:08 am
Well, I have a little stored procedure that, given another stored procedure name, generates a simple test harness.
Nothing rocket science: begin tran, declare all required parameters, set values (NULL by...
February 1, 2008 at 7:40 am
I must spend a bit of time looking into the factless fact idea. I am in no rush.
However, if I went for the initial solution, I suspect I still need...
January 31, 2008 at 3:42 am
I know you can set options regarding Snapshot isolation (allowing) and whether you want READ COMMITTED to be implemented via snapshot but I don't think there is more...
January 30, 2008 at 7:13 am
The backup drive is roughly 340Gbs and there is at least 120Gbs free when backing up.
The data drive is about 50% full (or empty...).
Having said that, we actually ran out...
January 29, 2008 at 10:39 am
Kind of... Makes me think!
I suggested to use a datamart instead of fullfilling the client's report request one by one and we are not planning to use Analysis Services (cubes)...
January 29, 2008 at 8:58 am
You may be right
I'll have to go back to his books (which I have read some time ago)
Thanks
January 29, 2008 at 3:00 am
Arati,
I don't have the answer to your question but I would question whether it's a wise idea to fire an SSIS package from within an ASP.Net page.
If what that package...
January 28, 2008 at 4:48 am
Which one?
Professional SQL Server 2005 Integration Services
or
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
January 9, 2008 at 6:46 am
Ok, got it!
Many thanks 🙂
January 9, 2008 at 5:41 am
What about if you create tempdb in the "same" location on both nodes...
For instance ona D:\TempDb folder?
The only thing that would get out of step is the actual size of...
January 9, 2008 at 5:26 am
Maybe you could setup a server side trace on database growth for the tempdb database...
That might help finding out who is requiring that space.
January 9, 2008 at 4:21 am
Actually... It works fine if I use the Ado.Net provider instead of OleDb
Thanks
Eric:D
January 7, 2008 at 7:11 am
I tried that but it seems to ignore the parameter names... and falls down if they are in the wrong order
:ermm:
January 7, 2008 at 6:57 am
Thanks
December 3, 2007 at 11:08 am
Viewing 15 posts - 301 through 315 (of 322 total)