Viewing 15 posts - 14,011 through 14,025 (of 59,063 total)
October 18, 2017 at 11:13 am
It's a well known fact that "managed" code can be and frequently is much slower and resource intensive than using properly optimized stored procedures. The key in this case is that no...
October 18, 2017 at 8:45 am
Thank guys for identifying the bloody obvious 😀
October 18, 2017 at 8:03 am
I have this problem.
At monday found this, so drop and recreate index, then execute...
October 18, 2017 at 7:48 am
Just a heads-up on this... this type of query can cause statistics to be constructed on every column it touches. That could cause some pretty good delays for INSERTs, UPDATEs,...
October 18, 2017 at 6:54 am
I think the people granting patents such as the "1-click" thingy need to find a new job. They've obviously not done any due diligence when it comes to "prior art"...
October 18, 2017 at 6:29 am
SELECT '$' + CONVERT(VARCHAR(10), CAST([ie].[Amount] AS MONEY)),October 18, 2017 at 5:55 am
October 18, 2017 at 5:52 am
any other solutions / explanations for this behaviour?
I do not feel comfortable with...
October 18, 2017 at 5:39 am
October 17, 2017 at 8:12 pm
The shortest thing would be to write a query that reads from the table and inserts the results into a common table using the undocumented and unsupported sp_MSForEachDB stored procedure,...
October 17, 2017 at 8:06 pm
ADDRESS
2248|("snake") ft NE, FTE 700
When...
October 17, 2017 at 7:14 pm
Lynn Pettis - Tuesday, October 17, 2017 4:53 PMHow do companies end up with people like this working with their databases?
The interviewers...
October 17, 2017 at 6:24 pm
What did you do? Download from Equifax?
I'm truly hoping that none of these files actually contain credit card numbers and other PII in plain text.
October 17, 2017 at 5:27 pm
I will soon be consulting to a company that is moving about 6 hours...
October 17, 2017 at 5:13 pm
Viewing 15 posts - 14,011 through 14,025 (of 59,063 total)