Viewing 15 posts - 1 through 15 (of 69 total)
If you have Enterprise (or Developer) edition you could implement Database-Level Action Audit, which includes DML actions. I haven't personally implemented this level of auditing, but I can't see why...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 6, 2013 at 7:04 am
I find slightly silly to install it with SQL Server Express if it's not meant to work??? :angry:
I seem to remember the reasoning behind this is to allow you to...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 3, 2013 at 3:56 pm
In my experience scaling out SSIS in that manner isn't possible.
In fact I have a Connect ticket suggesting this as a feature, and extending this concept further by connecting multiple...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 1, 2013 at 7:13 pm
Just building on what you already have...
SELECT Group, SUM(Received), SUM(Paid)
FROM (
SELECT a.ReceiverGroup AS Group, SUM(a.Value) as Received, 0 as Paid
...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
January 23, 2013 at 2:49 am
it has a column percent_complete that lets you know the progress
Although be careful, as it is not always accurate and very much an estimation.
Accuracy in my experience depends on...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
December 7, 2012 at 9:34 am
...is this the best way of doing it (there is a lot of database across multiple servers and some are large)
I like to use Ola Hallengren script for DB maintenance...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 23, 2012 at 4:59 am
Madhivanan-208264 (12/6/2010)
More methods are available herehttp://beyondrelational.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx
Awesome article Dave, and a great follow up (and hollistic) resource Old Hand. Thanks for sharing guys!
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 23, 2012 at 3:25 am
I have 20000000 records in table1 which i joined with another table on some criteria and computing the value and then aggregating all the records and displayed it into screen
From...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 22, 2012 at 9:10 am
I seem to remember that SQL 2008 doesn't ship with scptxfr.exe anymore, which leads to the assumption that there are no new methods for sql 2008... I could be wrong...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 22, 2012 at 8:59 am
Can't find anything in google about this. Thoughts?
Shot in the dark here, but you could try re-installing the latest version of .NET (4), I had a few issues with SQL...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 21, 2012 at 2:17 pm
Can someone tell me if this is possible to achieve and how? or to propose another approach...
I think the SSIS approach is fine (although maybe I would've done it in...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 21, 2012 at 10:36 am
You'll need to provide more information, such as table structure and what have you tried so far.
Check-out the link below (in my sig) for posting guidelines.
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 21, 2012 at 10:23 am
I dont think there is any difference in performance, but you could always check the execution plan to make sure!
/>L
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
November 9, 2012 at 3:45 am
Error 0xc020901c: Data Flow Task 1: There was an error with output column "LocalLanguageLabel" (18) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 29, 2012 at 4:06 am
So can we have good compatibility while developing linked server between 2008r2 and 2012 or do we need to have both servers on same page?
On a general level, I have...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 27, 2012 at 6:35 am
Viewing 15 posts - 1 through 15 (of 69 total)