Viewing 15 posts - 7,561 through 7,575 (of 13,469 total)
Here's a Calendar Table Generator that I put together; it features all US National Holidays, as well some other that were fun to research and code; if the holiday is...
May 18, 2011 at 2:14 pm
on the SQL2005 server, you'll want to download and use Microsofts sp_help_rev_login, which scripts out the logins on the other server.
then run the results on the 2008 server.
once the windows...
May 18, 2011 at 12:03 pm
ugh;
no dev area and developers making direct changers to production(since it;'s the only work area?); Paul's advice about liquor and updating the resume sounds even better now....
how about a...
May 18, 2011 at 7:46 am
DBAgal (5/18/2011)
May 18, 2011 at 7:21 am
a rename of an existing object doesn't count as a DDL operation, so it wouldn't be in the default trace; I investigated that on a similar thread previously.
you'd want to...
May 18, 2011 at 7:06 am
here's one way to do it; I'm just creating a table full of high ascii chars, cross applying them, then using patindex to filter:
with mySampleData
As
(SELECT top 255 row_number() OVER (ORDER...
May 17, 2011 at 1:49 pm
PhilPacha (5/17/2011)
-c controls the output of data - in this case, "character."
-r controls the row delimiter
-c -r /n
Review the "BCP" entry in Books Online.
Everything...
May 17, 2011 at 12:52 pm
homebrew01 's method is exactly how I've done it in the past.
now for "special characters", what does that mean? high ascii?(so you have to export the results as NVarChar?), html...
May 17, 2011 at 12:00 pm
Don't Panic: MERGE is just a fancy way to do what you've already done a zillion times:, but as separate steps...INSERT new rows, UPDATE matching rows, DELETE rows that were...
May 17, 2011 at 6:07 am
martynjreid (5/16/2011)
Welsh Corgi (5/16/2011)
What time constraints are you looking at?The ETL process takes anywhere from 30 mins to 8 hrs dependant on hardware and size of the source database.
dumb question...
May 16, 2011 at 4:41 pm
for me the big question is the number of rows moved;
when your procedure was running once a day, what did it do? MERGE statement? drop and recreate the data?...
May 16, 2011 at 3:06 pm
is an error returned, or just no data?
check the schema of the underlying objects inside the view;
for example, lets say dbo.View1 & 3 are accessing items under the same schema,...
May 13, 2011 at 11:47 am
browsers ignore whitespace...tabs, CrLf and more than one space in a row; that's part of the html definition
if you need to visualize whitespace, you'll need to html-ize the results...either by...
May 13, 2011 at 6:22 am
how about adding a column to your records to have an opt out date and optional reason in the database row for the emails; then when select FROM YourTable where...
May 12, 2011 at 7:53 pm
it's syntax: remove the word "SELECT" just before EXEC;
looks like an artifact from trimming the code.
May 12, 2011 at 11:42 am
Viewing 15 posts - 7,561 through 7,575 (of 13,469 total)