Forum Replies Created
Viewing 15 posts - 2,071 through 2,085 (of 59,065 total)
-
Reply To: SQL on Hyperv
Jo wrote:Then there is still the cpu 'topping' issue. We can not comprehend that the cpu cuts off at 12.5%. spot on 12.5% (the limit?)
You said you have 8 CPUs. ...
-
Reply To: Can I set timeout for a query?
oRBIT wrote:I mean within the SQL itself. Assume something like this fictional code:
IF (condition...) BEGIN
SET EXECUTION_TIMEOUT=1000 SELECT * FROM dbo.VeryLargeTable -- If the above select-statment takes more than 1000ms it...
-
Reply To: Incorrect syntax near the keyword 'on'.
I also missed the leading wildcards in the criteria... be advised that will cause a full-scan of the table/index. No index seek will be possible.
-
Reply To: Incorrect syntax near the keyword 'on'.
It looks like many of your ONs should be ANDs, instead.
-
Reply To: Remove a Filegroup
amy.walsh wrote:You might not be able to drop the filegroup because something still remains on it. Here are a couple of queries copied from other locations on the internet that...
-
Reply To: Learning Leads To Learning
On that note, here's an article that might be of interest to you, Grant.
https://www.smithsonianmag.com/innovation/morse-code-back-looking-ditch-twitter-180981309/
-
Reply To: What “paths” may I have as a future Python developer?
Heh... this is more what it reminds me of in a couple of the places I do work for...
-
Reply To: Troubles with in memory OLTP performance degradation
tommiwan wrote:Due to the nature of the business they shut the servers down each night and turn them back on in the morning through automation.
I have to ask... what "nature...
-
Reply To: The Programming Languages We Use
David.Poole wrote:The most relevant speed to a business is often the speed at which you can deliver business value.
That's always true. The problem with that is the panic that ensues...
-
Reply To: SQL Query to fill in Null Column values based on closest date to a given date
Maybe I'm still suffering from insufficient caffeine levels this morning, but I have to admit, David, I'm confused. Why did you change the row numbers from what the op originally...
-
Reply To: Cant extract values from JSON Array
Totally understood on that... but do you suppose that they'll actually use your good code to "normalize the data" and store that normalized data in a database or store the...
-
Reply To: The Programming Languages We Use
Eirikur Eiriksson wrote:He he he, are you selecting the tool before the job? 😎 "when you have a hammer, every task is a nail"
Also remember that when you're trying to...
-
Reply To: The Programming Languages We Use
As a bit of a sidebar, I just watched the day 3 presentation that Kimberly Tripp gave. It seems that really old technology still prevails and that technology is SQL...
-
Reply To: Cant extract values from JSON Array
Steve Collins wrote:The alternative involves custom coding/recoding to and from SQL Server data types, no?
You just wrote custom code on the database side of the house by including INT and NVARCHAR(MAX)...
Viewing 15 posts - 2,071 through 2,085 (of 59,065 total)