Viewing 15 posts - 931 through 945 (of 1,995 total)
Given that most medium to large companies predominantly use HP... you don't have much of a choice.
My antique home PC is an AMD Athalon 3400 and it has served me...
July 22, 2019 at 8:04 am
Hi prettsons
that's cool info for anyone facing the same issue. I did all of those things but at checkdb stage I got the error message I mentioned, as I posted..
in...
July 4, 2019 at 9:09 am
happy to. Give me a day or 2 and it will be in your inbox ready for you to edit. 🙂
July 2, 2019 at 8:54 am
yeah... that was my first approach
It actually turns out that it was a memory issue. (it was quite a big database, so it took quite a while to go through...
July 1, 2019 at 2:51 pm
just a normal backup database->restore database scenario
I'm going to try dropping the allocated memory on the target server and see if the issue is "not enough free memory to create...
July 1, 2019 at 1:34 pm
The theory of constraints says that there is ONE key constraint at any one time. If your work addresses this constraint then another will emerge and it won't...
June 19, 2019 at 12:33 pm
It worked out well because, when people ask me why their code had performance issues, I could tell them, "Well, if you had used the fn Tally function...
June 19, 2019 at 9:01 am
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"
...
June 18, 2019 at 11:12 am
Lol
I work for a company that was founded in 1851. our practices are built on fax machines. (seriously, at one point I dreamt that our DR scenario revolved around faxing...
June 12, 2019 at 1:04 pm
while it's slightly off topic,
I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"
but I do agree with...
June 12, 2019 at 12:31 pm
Herb (and anyone interested) - I highly recommend reading a book called "the phoenix project"
it details the story of and IT engineer in an engineering company, trying to get things...
June 12, 2019 at 8:23 am
without seeing the table structure or the data it is returning we will struggle to help
have you thought about using Row_number() over (partition by … order by …) as rn
add...
June 11, 2019 at 3:15 pm
next you'll be telling us Santa Clause and unicorns don't exist
June 7, 2019 at 8:08 am
I hate "where 1=0" - I ..use "where @debugmode=1" and pass that in as a parameter. the number of times one of my devs has hardcoded "where...
June 5, 2019 at 2:00 pm
you could keep your existing clustered index on the publisher.
then set the article properties to not copy indexes. then create a post snapshot script that creates the clustered index to...
June 5, 2019 at 1:26 pm
Viewing 15 posts - 931 through 945 (of 1,995 total)