Viewing 15 posts - 1 through 15 (of 68 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...
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...
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...
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
...
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...
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...
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!
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...
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...
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...
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...
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.
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
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...
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...
October 27, 2012 at 6:35 am
Viewing 15 posts - 1 through 15 (of 68 total)