Viewing 15 posts - 676 through 690 (of 59,060 total)
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...
March 10, 2024 at 9:24 pm
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the...
March 10, 2024 at 9:21 pm
The *data* file drives should be 64K. Log file drives should still be 4K. If you mix data and log files on the same drive, you'll want to use...
March 7, 2024 at 6:07 am
Hi All,
I have a data in column A in where in need to achieve the count which I have mentioned in column B. Please find the attached excel dataset...
March 7, 2024 at 6:00 am
thank you both! i know how to fix my query now because of your feedback. thank you again for the help!!
Cool. Can you show us what you settled on?
March 6, 2024 at 5:13 am
I'll take a smart "Pepper" (think Iron Man) over an AI all day long. And, no... not for looks... for smarts that I can trust instead of having serious doubts. ...
March 6, 2024 at 5:09 am
I got my "best job ever" by answering the ultimate ad for someone that knows SQL...
"We need someone that can look at SQL, figure out what's wrong, and fix it".
That...
March 4, 2024 at 6:23 pm
Please see the following article for how to capture the results for all databases. What most people don't know is that most of the DBCC commands will allow for the...
March 3, 2024 at 9:48 pm
can you please provide optimized t-sql query . Thanks in advance.
Like has already been stated, it's pretty much impossible to help with performance issues just by looking at code. ...
March 1, 2024 at 5:53 pm
Whoof! 500 rows took 12 minutes? Honestly, that should be something that occurs in, at most, a few seconds.
Indexes may help (they can also add overhead to deletes as...
March 1, 2024 at 5:49 pm
I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.
Just adding my 2 cents... That...
February 28, 2024 at 2:54 am
this is super interesting. i didn't know that.
this begs the question....how do you decide on an appropriate index? is there a good resource you can suggest that goes over...
February 27, 2024 at 3:03 pm
does it make sense that an unindexed query is faster than an indexed one?
Oh yeah... and big time! There are many reasons why such a thing may happen. For...
February 25, 2024 at 10:01 pm
Your question is easy to ask and can take years to answer.
It sounds like you could stand a lesson on what an "Execution Plan" is. Please see the following link...
February 25, 2024 at 5:14 pm
I was running a SP and I got this. This is the first time I have ever received this. What does it mean? How do I fix it so...
February 25, 2024 at 4:48 pm
Viewing 15 posts - 676 through 690 (of 59,060 total)