Viewing 15 posts - 1 through 15 (of 171 total)
As previous answer said there's not much you can improve without using indexes. The problem is in the very business rule and in the naure of the data.
September 5, 2017 at 8:36 am
I remember focusing in XML and service broker just because never used those features.I practiced 1-2 hours/day for a month and passed the exam.In those fetaures I'm not...
August 15, 2017 at 9:48 am
I passed the 2005 exam and at the time XML queries was a new feature so you can say it was on the exam (a big part of it) for...
August 14, 2017 at 10:39 am
Fortunately we have trace running in production.Analysing the data I found an 'ALTER LOGIN' being doing in the 'MASTER' system db.
But it still strange because those commands...
August 1, 2017 at 2:25 pm
Thanks everybody insigths
Looks like they told me a different tale after all
The sql guy give me two databases to test performance and told me both are...
April 20, 2017 at 8:45 am
Thanks for the reply.
Actually the partitioning was not my idea and I'm too ignorant (of partiotioning) to take sides.My guts tell me there's something else wrong. Partitioning...
April 18, 2017 at 10:32 am
Thanks for all replies.
About the deadlocks:
- The deadlock problem don't appear to be directly related to the ANSI_NULL off.
- We cannot reproduce it on test but on production it popups...
August 3, 2015 at 8:42 am
Thanks guys for your time it appear I overlooked it on the wrong place.
After double checking everything else I checked a schedule thing that services uses to expires the postponed...
August 28, 2014 at 2:42 pm
That [IncidentDetails].[InsertDate] columns keeps the modification timestamp.
No no other operation and the user is a trained tester looking for this kind of issue, unless he manualy updated that value at...
August 28, 2014 at 6:29 am
Funny thing is for some view points MS SQL Server is a "rule them all" system.
(and let's not forgot that good tools integrated to it like red gate) 😀
August 13, 2014 at 8:40 am
I got the same problem.
A staging server is using collation_B and the Production server is using collation_A
Te staging server host a lot "unrelated with the problem" DB from other depts.
August 11, 2014 at 2:49 pm
Old but gold!
I like your script and added the feature do search uniqueidentifiers (because I needed it)
and added to skyp not online DataBases and some sebug in case it fails...
August 7, 2014 at 6:37 am
Surveys don't tell the whole history but for sure social engineering makes people the weakest ring in the chain.
If scams/spams and phishing are not profitable they cannot be increasing day-by-day.
February 19, 2014 at 5:41 am
I guess there are not to worry about unless there are many records with the same omsId and recordType, this can cause a cartesian product in that self join as...
November 27, 2013 at 3:15 am
MS hardly admits problems.
As a old joke said "...MS is a marketing corporation with serious software issues"
At forums and MSDN they often use the "its by design" or "its a...
November 21, 2013 at 9:11 am