Viewing 15 posts - 3,121 through 3,135 (of 59,067 total)
Heh... Lordy. How did I remember this? It's definitely an SQL "Oolie".
July 22, 2022 at 5:41 am
I have a friend DBA where there's no real blame for anything and that's good but there's no real push to get smarter about things, either. They're going through the...
July 21, 2022 at 4:52 pm
How fix SQL performance issues? Start by checking your wait stats
2-Make sure you're running index maintenance frequently.
Everything Jeff said.
But, one exception, columnstore indexes. Reorganization and rebuild do...
July 21, 2022 at 4:40 pm
Hey there!
Each winning/drawn number has its own row, however you would probably unpivot the data in both tables so that you have a key for which group of numbers...
July 21, 2022 at 4:34 pm
licensing is extra confusing in the cloud. Sometimes licensing is included in an Azure SQL, sometimes not. You could easily be double licensed as not licensed at all
Azure...
July 21, 2022 at 1:31 pm
What is the datatype of @P8? If it's not NVARCHAR(), it will ALWAYS do an index SCAN because it first has to convert all of the rows in the entire...
July 20, 2022 at 1:58 pm
Just an opinion but using XML to transfer data between servers seems counter productive to me. Instead, I'd have a common area that all the servers could write to and...
July 19, 2022 at 3:12 pm
You also have to remember about licensing of SQL Server on spin-ups. I've never seen anything written about that but, disclaimer, I've not looked for such a thing. I only...
July 19, 2022 at 3:01 pm
After changing just the compatibility level, queries are running efficiently. Thanks all...
That also means that you may be missing out on some newer technology in the database engine. It...
July 19, 2022 at 2:51 pm
To split out the pd_id's you could try STRING_SPLIT to separate based on space delimiter. Since some 'PD-[0-9]' values are encompassed by other extra characters a conditional substring is...
July 19, 2022 at 2:58 am
i understood in case of storedporcedure , but in case of the function.
I logged in using the user "login s2" then executed the function "s1.xyz" which is in schema...
July 17, 2022 at 9:46 pm
Question for the smart people, and the rest of you.
Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.
Or is...
July 17, 2022 at 5:51 pm
p.s. There's no way that I'd take all the time to upgrade 2012 to 2019. 2019 is already 3 years old and 2022 has some fairly handy new things and...
July 17, 2022 at 4:14 pm
Viewing 15 posts - 3,121 through 3,135 (of 59,067 total)