Viewing 15 posts - 241 through 255 (of 13,457 total)
you want to use Datetime for all values
here i am stripping out time to get the first day of the current week/Monday, and adding either one or two...
February 4, 2019 at 11:14 am
one of the know requirements when you upgrade is to update statistics for all tables, as the optimizer is different.
did you rebuild your indexes/update statistics yet, after upgrading to...
February 3, 2019 at 8:24 am
you want to store it with the line feeds in place already.
INSERT INTO YourTable ( ID, NickName,Category,Phrase)
SELECT 1,'excitedBirthday','Birthday',
'I bet you''re so excited
Excited...
February 3, 2019 at 6:34 am
its also possible with OpenXML and a script task, but the learning curve to learn to get that right is pretty steep.
once you have it though, you can decide...
February 3, 2019 at 5:36 am
stick with the SSIS wizard and avoid a linked server.
the SELECT INTO FROM linkedServer... will be a massive logging operation, and you might run out of disk space due...
February 3, 2019 at 5:29 am
yes, i store queries like that in a table, and execute them all the time.
there are two simple ways, note i had to escape the single quotes within the...
February 3, 2019 at 5:24 am
grid view always compresses the data to a visible sinlge row, and makes CrLf appear as spaces.
what you want is to make sure a copy/paste from a grid still...
February 2, 2019 at 5:27 pm
here is an example, splitting the list of all your tables in your current database, into five columns;
i think you can adapt that to only have four columns,...
February 2, 2019 at 11:33 am
the issues is object owner chaining. cross schema or cross database queries break the object chaining inheritance, and require select permissions to teh underlying tables.
you don't want that, you...
January 31, 2019 at 1:06 pm
if you have the enterprise version, Data Driven subscriptions are an option.
with data driven subscription, you might have a view that has all the info on a per row...
January 25, 2019 at 2:50 pm
here's a scripts i actually put into views ie (GoodMail and FailMail) by toggling the WHERE statement; very handy for at a glance status of emails.
so i can review...
January 24, 2019 at 9:19 am
I would assume that some other process is toggling all rows back to zero, and not that SQL is not updating after it explicitly said it updated/Completed.
January 23, 2019 at 7:16 pm
this link describes numbered procedures fairly well; it is a little used capability that is now deprecated.
you can have different versions of the same procedure, or even completely...
January 23, 2019 at 10:36 am
i've been using a modified version of this script sp_help_revlogin_roles, which scripts logins and some server roles for you for an easier migration:
https://www.itprotoday.com/strategy/cloning-security-objects-between-servers
January 21, 2019 at 2:30 pm
sp_send_dbmail is asynchronous. the whole process is already a service broker.
it returns success and an mail_od immediately without actually sending anything, and puts it in a queue.
the...
January 21, 2019 at 12:13 pm
Viewing 15 posts - 241 through 255 (of 13,457 total)