Viewing 15 posts - 916 through 930 (of 2,649 total)
on top of what Sergiy said do have a look at the indexes as well - some can likely be removed as follows - and this will remove one of...
March 5, 2022 at 9:13 am
it was me - had already clicked button when I noticed mistake - did send the OP a message apologizing.
and yes it was pressure due to the spam abuse over...
March 2, 2022 at 11:08 am
and.... SA user should not be enabled at all!!!
and should not be used by ANY application either.
February 28, 2022 at 3:12 pm
been cleaning/blocking users as fast as I see them - but site managers should look at automatic rules as all those I did over last 3 days would be easy...
February 28, 2022 at 3:08 pm
This person is in way over their head.
one of those I refuse to help now - ignores suggestions and fails to supply requested information and just wishes for...
February 22, 2022 at 4:37 pm
I would look at PowerBI and Excel. You can use stored procedures and views as data sources if you want. What kinds of graphs etc did you want...
February 19, 2022 at 3:42 pm
if I got it correct the following likely to perform better - do look at the comment inside it - and as with everything test test and test again.
February 15, 2022 at 12:31 am
on top of using a non supported configuration - and potentially some licensing issues on that also (Office is not licensed to run on a server).
but that aside move that...
February 14, 2022 at 11:27 pm
you can't - dynamic sql required to do it and its not possible on user functions - see https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/create-user-defined-functions-database-engine?redirectedfrom=MSDN&view=sql-server-ver15
and even if you could it likely would not be advisable at...
February 12, 2022 at 7:03 pm
he/you can extract all packages to an .ispac, extract the .dtsx files from this (its just a .zip file) and then search/parse the packages for it. - that will give...
February 10, 2022 at 9:25 pm
Just as a straw poll, what if we had threads older than 1 year - latest post date <= dateadd (year, -1, getdate) - closed when someone tries to...
February 9, 2022 at 7:04 pm
I feel like that list is proof that Grant and Jeff are the same person, as they have exactly the same amount of subscriptions.
No.
You've got that all wrong....
February 9, 2022 at 7:01 pm
I did not see my name on the list but for me you can unsubscribe me from any that is older than 1 year.
should anyone post something and bump the...
February 9, 2022 at 6:42 pm
No need for UNION:
INSERT [PW].[Contract] ([ID],[ProgramID],[PAContractNum],[PAContractAmt],[PAContractStartDate],[PAContractExpirationDate],[CreatedBy],[CreatedOn],[UpdatedBy],[UpdatedOn]) VALUES (1, 8, '15FHBFPP0115', 0.0000, '2014-07-01 00:00:00', '2016-06-30 00:00:00', 'some.person', '2015-02-11 00:00:00', 'some.person', NULL)
,(2, 8, '15FHBFPP0102', 0.0000, '2014-07-01 00:00:00',...
February 7, 2022 at 7:23 pm
message is very clear - either you do those changes through SQL or you change the option that prevents you from doing the change when using the DESIGNER <--
February 5, 2022 at 11:20 am
Viewing 15 posts - 916 through 930 (of 2,649 total)