Viewing 15 posts - 5,536 through 5,550 (of 22,211 total)
I see information about speed and size. I don't see transaction through put, volume or speed, simultaneous users, high availability, disaster recovery, all the things that SQL Server provides.
However,...
September 10, 2015 at 3:03 pm
Got a request for the SQL Server monsters.
I'm working on the first draft of the final chapter of the complete rewrite on the execution plans book (HUZZAH!).
It's on 3rd Party...
September 10, 2015 at 12:13 pm
DSNOSPAM (9/10/2015)
September 10, 2015 at 9:50 am
Why is there a GROUP BY when you're not doing any aggregations that I can see?
September 10, 2015 at 8:47 am
First thing I'd do is replace all this mess with OR clauses:
( COALESCE(VMI.CompanyName,VMI.CompanyName )
That is going to absolutely destroy any chance of good index use. Don't use functions against...
September 10, 2015 at 8:46 am
What Chris is saying is, you can't just reference the parameter value like that unless you change it to a table valued parameter and then do a SELECT or JOIN...
September 10, 2015 at 7:52 am
Let's start from the bottom.
The free stuff, like PASS, can be as deep as you want it to be. It really depends on the class and the instructor. I teach...
September 10, 2015 at 7:42 am
Sean Lange (9/9/2015)
Grant Fritchey (9/9/2015)
Fair warning though, a shocking number of vendors are really horrible at SQL Server.
Gosh Grant the way you say that makes me think you have the...
September 9, 2015 at 11:06 am
It actually sounds like the process takes out locks in the database while the files move. I would classify that as a bug in the application code.
However, I agree. You...
September 9, 2015 at 10:17 am
You really need to take the log backups more frequently. Once an hour at least. That puts you in a situation where you could lose up to an hour of...
September 9, 2015 at 6:05 am
I especially don't understand the "move big folders from the application" part of the problem. That sounds like file manipulation which is not usually something done within the SQL Server...
September 8, 2015 at 4:19 pm
Alvin Ramard (9/8/2015)
Steve Jones - SSC Editor (9/8/2015)
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
September 8, 2015 at 10:26 am
Well, I'm wrong today. Microsoft says that they fixed in the newer version of the documentation. Of course, if you look at the old documentation...
September 8, 2015 at 10:24 am
If you're saying that the application is attempting to pass 3 parameters but the stored procedure only accepts 2, then the fix is with the app. There's nothing you can...
September 8, 2015 at 8:58 am
Thanks. Passed the word on. Gail, if you feel like piling on, please do so.
September 8, 2015 at 8:56 am
Viewing 15 posts - 5,536 through 5,550 (of 22,211 total)