Viewing 15 posts - 3,421 through 3,435 (of 59,067 total)
In case it is of help to anyone.
My problem was the case sensitive, ENGLISH or ITALIAN is not valid but English or Italian work OK.
Hi and welcome aboard. That's...
May 23, 2022 at 7:45 pm
not like that. if the user comes back will provide the data.
But in general, it is obvious that when data is less and return rows from it will take...
May 23, 2022 at 7:41 pm
I'm not sure that I'd trivialize the roles of Data Scientist or Data Analyst like that. I know a whole lot of people that write some great T-SQL that would...
May 23, 2022 at 6:29 pm
"Best way to learn T-SQL for MS SQL Server"?
Start at the beginning. See the following link with the understanding that it does cover more than just T-SQL and some of...
May 23, 2022 at 6:22 pm
my key is company and year and rev and not repeated
What, from your example code, would constitute "repeating data"? If the answer is "none of it", then we need...
May 23, 2022 at 6:14 pm
Try taking a look at theses 2 management views. Change the ORDER BY in your queries to get highest use per I/O, CPU, Memry sys.dm_exec_query_stats
May 23, 2022 at 6:09 pm
We have about 160 instances of "WHERE (1 = 1)" or "ON (1 = 1)" in our code base and 950 of "CROSS JOIN".
The code base has about 2.6m...
May 23, 2022 at 6:02 pm
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have simple recovery mode. Problem is that transaction log file is not shrinked automatically, current size...
May 23, 2022 at 5:38 pm
To seriously summarize, it looks like you have a bit of a hot mess on your hands and you have no clue as to where to even start looking. I...
May 22, 2022 at 7:14 pm
I agree that MS says the 15 second warnings are only due to hardware. I have no actual written proof but we've tested. All our stuff is on some killer...
May 22, 2022 at 7:06 pm
Run it manually once with the execution plan turned on.
Also, look into Brent Ozar's "First Responder Kit". It's free and the code is open for you to use to learn...
May 22, 2022 at 6:43 pm
Let's see this simple query that you're talking about. See the article at the second link in my signature line below.
As for all the excuses you gave for their queries,...
May 22, 2022 at 6:33 pm
Anyone has any perfmon.msc file to measure how busy is my sql server?
I do... but PerfMon is a picky thing... what works on one box frequently doesn't work on...
May 22, 2022 at 5:26 pm
How can sp_whoisactive help?
Have you searched for it yet? No sense in me repeating something that's readily available. 😀 Reading about it is a lesson about SQL Server in...
May 22, 2022 at 5:23 pm
How to identify if it is M.A.R.S and disable it?
There may be another way but we had our developers check the actual connection strings they were using. It was...
May 22, 2022 at 5:17 pm
Viewing 15 posts - 3,421 through 3,435 (of 59,067 total)