Viewing 15 posts - 3,361 through 3,375 (of 3,475 total)
Big topic. You might want to start by looking up partitioning. Do you need to keep some of the records in the table "active"/editable while others are not?...
May 4, 2013 at 5:33 pm
You could also do this in Reporting Services with a Matrix...
April 30, 2013 at 11:10 pm
did you back up and restore MSDB from your old server to the new one? that's where the jobs are stored.
April 24, 2013 at 10:54 pm
Why not split the two types out inside SSIS:
select someData, ISNUMERIC(someData) As NumTest
from test
WHERE ISNUMERIC(someData)=1;
The example is kind of overdone, but the idea is that you can test/filter for whether...
April 24, 2013 at 10:50 pm
It's because they know how to use the Force, and we don't...
Silly Us!
April 9, 2013 at 6:06 pm
Might do that... they have Access and VBA is easy... forgot about doing pass-through queries... Makes a nice front end, but not my favorite as a backend.
March 26, 2013 at 9:24 am
As I understand it (doesn't mean it's right), each salesperson is assigned to one or more geographic areas, and the customers are inside them, so it should be hierarchical. ...
March 25, 2013 at 4:34 pm
That's what I thought... I have no idea how else to do this besides RLS. (Thanks for the warning of how much fun it is... at least now I...
March 25, 2013 at 3:28 pm
I had seen that article before, I'm now I'm walking through it. I noticed that the locations were already geocoded, so that's how the solution works. I did...
March 20, 2013 at 9:57 pm
FWIW, Yuri's code, ProcessAddress() that used Yahoo's geocoding services used to return the County, but that appears to not work anymore.
If I can't get that to work, is there a...
March 18, 2013 at 9:16 pm
what happened when you tried it?
looks like the only thing missing is the ORDER BY clause to force a sort in descending order (so you get the highest values)
March 13, 2013 at 10:47 pm
Before doing anything like that, know what you're getting into. Read this: [/url]
Gail explains in detail why this is a bad idea, and the one or two instances when...
February 28, 2013 at 6:23 pm
I would check out Gail Shaw's articles. She writes extensively on transaction log management, and knows what she's talking about.
February 10, 2013 at 12:02 pm
I disagree. Maybe check in the front end or the stored procedure used to write the data to the table, but changing a NULL to N/A adds absolutely no...
January 6, 2013 at 2:44 pm
lonhanner (12/18/2012)
December 18, 2012 at 7:59 pm
Viewing 15 posts - 3,361 through 3,375 (of 3,475 total)