Viewing 15 posts - 121 through 135 (of 136 total)
The remote table is roughly 70,000 rows.
March 2, 2012 at 7:33 am
As someone with lots of DBMS experience, but new to SQL Server, I have found the SSC community to be an invaluable resource. I try to use BOL to...
January 30, 2012 at 7:54 am
It boils down to this: does the manager care? If not, no amount of information will change that. (Although maybe pressure from their manager might.) If the...
January 30, 2012 at 7:36 am
We frequently have SSRS reports that compare this month vs last month. I use synonyms in the main report query in order to avoid the messiness of constructing a dynamic...
January 10, 2012 at 11:05 am
Hi Steve,
I was just thinking of MS-Access 'linked tables' when I wrote that. The Synonym command resemble that ability. I should have said 'allows me to create a...
January 10, 2012 at 7:51 am
A great little hidden gem, and thanks for pointing it out. One bonus of using synonyms (I've just learned) is the ability to GRANT or DENY privileges on the...
January 10, 2012 at 6:32 am
I'm still learning SSIS, but this has a lot of good information and tips. Looking forward to Part II.
January 5, 2012 at 6:11 am
If anybody's still listening, I've run into a small wall in SSIS. I get a quote-delimited CSV file that I want to upload to a SQL Server temp table....
December 23, 2011 at 10:36 am
It's a good point about how to manage the volume of files in that folder. These are files that can be discarded after upload, but it's a problem that could...
December 21, 2011 at 1:58 pm
Thanks, kramaswamy, this is very cool stuff; I would have spent a week putting this altogether the way you've laid it out. Thanks for the advise on running a job,...
December 21, 2011 at 11:48 am
All right contestants, here's a 5-point tossup for anyone:
Let's say I want to import a CSV file with this process every day, and this file comes to me with the...
December 21, 2011 at 11:19 am
kramaswamy,
Thank you for all that practical advice. I'm taking your advice to do the temp table and do the update with a sql statement. One more question, please. ...
December 21, 2011 at 9:45 am
Another issue for technical types is that we sometimes have to deal with managers who don't fully (or even partially) understand what we do or what we're even talking about,...
December 20, 2011 at 7:17 am
I couldn't agree more. I've had jobs over the whole spectrum of work environments, from outright aggression and paranoia right up to total trust and love. (Well, it was...
December 20, 2011 at 5:41 am
In SQL Server 2005, right click on a database name, select "Tasks..." and then select "Export Data..."
This runs the DTS Wizard from within the Management Studio.
December 19, 2011 at 1:57 pm
Viewing 15 posts - 121 through 135 (of 136 total)