WHERE CASE WHEN DATEPART(DAY,FDFundingDate) > DATEPART(DAY,pl.Userdate) THEN DATEDIFF(MONTH,FDFundingDate,pl.Userdate) - 1 ELSE DATEDIFF(MONTH,FDFundingDate,pl.Userdate) END < 37
His "answer" basically shows where an OUTPUT clause would go, if the syntax were valid, which it is not. Lazy-ass answer I down-voted and closed the tab.
Hey Kermit, this question is asking for help with a strategy on the search for the right database. It is not asking for specific recommendations. For example, what key terms should I be searching for? Are there classes of databases that fit this use case to a greater or lesser degree? I am familiar with the term "low-latency" but I'm not sure what term applies to a database that is delete tolerant. — Chris Dutrow22 mins ago
I have a very complex logic SQL Query which has many case statement.
It is running very slow.
It has 7 Left Join tables.
Updated Execution Plan Link
Below Statistics of sample query.
what could be the possible reason for high worktable logical read?
It takes a lot of time to execute.
Neithe...
"Sorry, you can't view or download this file at this time.
Too many users have viewed or downloaded this file recently. Please try accessing the file again later. If the file you are trying to access is particularly large or is shared with many people, it may take up to 24 hours to be able to view or download the file. If you still can't access a file after 24 hours, contact your domain administrator."
@swasheck Oh, well I learned something. 2 somethings actually. The first was that in the nested construct, I can't just pull back the INSERTED table and then it still won't work with a JOIN or APPLY
Eep, I don't even know where to start with this one - and not just because the query is so large the showplan XML can't contain the whole thing. Why do you have so many heaps? Kesjer scared you away from clustered indexes? — Aaron Bertrand ♦32 secs ago
Munin's formula for "device utilization" is (milliseconds spent doing I/O)/second, which assumes you can't do any I/O in parallel, so I'm not sure that this is a meaningful metric. However, you do clearly have a genuine performance issue here since replication can't stay caught up.
Is there a si...
Indexes don't help all that much if they're not covering. Did you know I counted 55 RID Lookup operations? I'm really not surprised it is slow but this is a whole slew of underlying schema problems that can't be solved here. — Aaron Bertrand ♦47 secs ago
@PaulWhite I was thinking 7 joins (5040 possible join orders I think) probably isn't too many for the optimizer to consider, but I guess the bigger issue is estimates degrade due to hidden/unknown (to the optimizer) correlations?
Yeah he described 7 left joins in the question but either he was conveniently leaving out a bunch of inner/right/cross joins or these are joins to views that themselves contain a boatload of joins.
@James 5040 is only the possible orders. Multiply by the ways that a join can be done (merge join, etc.) If every join has 3 options. that 3^7. Now we have 5040*2187 = 11022480
@AmritpalSingh Sorry, but it's just too big and there are far too many problems to make a useful Q & A here. You need a consultant, not an answer. — Aaron Bertrand ♦12 secs ago
You tried to kill the process? sigh That wasn't a spreadsheet you were trying to recover. Best of luck. Call Microsoft support. — Aaron Bertrand31 secs ago
@AaronBertrand Well it does at least sound like they were working on a local copy of the database. Or their production database is on the developer machine, but...I don't even want to think about that. :P
@AaronBertrand I was going to tell him to have some patience, and wait for SQL Server to run recovery; but then I thought "clearly this guy has no patience".
I'm trying to make a stored procedure to verify a input INT have maxim 15 digits and the first digit is not 0.
And now I have this:
CREATE PROCEDURE usp_verify_phone_numbers (@phone_number INT)
AS
IF @phone_number > 15
BEGIN
PRINT 'Not ok'
END
ELSE PRINT 'OK'
DECLARE @...
When you restart SQL Server, it will run the "recovery" process on all databases configured to load at startup. You need to wait for recovery to complete; at which point the rows will likely still be in the database. A word of advice, wait for SQL Server to do it's thing; NEVER kill the sqlse...
So, I'm lost. The table definition for PurchaseReturn already has a foreign key constraint to PurchaseOrder set to cascade. Are you trying to add another one? Why? Are you trying to change it? It seems to be named incorrectly (it has VEN in the name). Drop it before you try to fix it or add different constraints that will currently point to the same table... — Aaron Bertrand1 min ago
@bluefeet my dogs are 7 and 8 and they are more a PITA now than when they were puppies
I don't understand people
@AaronBertrand Those cases will be very rare, if not zero, in this dataset. Having said that, I would like to be able to handle .net and .info if possible. — zgall136 secs ago
So it's not important, but give me a solution for it
@AaronBertrand I've got 3 dogs - 13, 7, and 2 - they can for sure be pains. But they are kenneled at night. little dogs have the tendency to be incredibly active in the wee hours
@AaronBertrand, first foreign key is created on Column 'VendorId'. But I want to add another FK on column 'PurchaseorderId' that is refrenced to Purchaseorder(purchaseOrderId) — Khan1 min ago
I'm done, SO idiot:not-idiot ratio is just getting way too high for me
UPDATE MyTable
SET website = LEFT(website, CHARINDEX('.com',website)+4)
Note that this won't work if you have anything other than .com in the first domain name.
Edit: A comment mentions it won't work with domain names that has .com in the middle like www.COMputers.com or www.COMmander.com. ...
Manually, like what, in Edit Top 200 Rows?
(I know, I was supposed to log off, got the stupid ping from my comment on the question.)
Do an UPDATE for each, replace the .com with .net, .org, etc. SQL Server has very poor Regex support so you can't do it in a single statement. This filtering best happens at the application logic level, before it enters SQL Server. — Zoff Dino34 secs ago
That is just absurd - how are you going to get the list of PK values to put in all of those manual update statements? How are you going to fill in the ...? Again, you are suggesting that you manually and visually inspect every row. Absurd. — Aaron Bertrand1 min ago
eventually consistent. but i'm not miffed. based on brent o and bobby seahawks' comments on tom's post, it's like any other election. you vote for someone who's not going to do anything that they said they were going to do in the first place
@MikeFal she was so cool. we'd never met. i insulted her by asking her where she was from but after that, she talked to me like we'd been friends forever. she still never got my name (which i'm sure she's better off)
@AaronBertrand what i think is funny is how much the board seems to want to cater to the rockstars (ahem) ... and one of the biggest personalities in the cult is turning it back on them
@AaronBertrand That's kind of my thought. Brent grandstands a lot, but he usually says stuff that I agree with. I may not agree with his approach, but he has an effect.
@AaronBertrand It did seem like he purposefully misconstrued Chris Webb's comments to be more dramatic, but other than that I can't say that I disagree.
"The main limitation of PASS BAC is that it's a Microsoft-centric conference on data analysis. That's like having a World Cup with only the U.S., Canada, and Belize."
we just start our own ... U-ASS ... Unprofessionall Association Sql Server
2
@AaronBertrand like a midnight cowboy. also, i have no mvp or any accolades or recognition to lose ;) ... just my dignity and @billinkc has already taken most of that from me
> Nobody could ever find out what a particular voter has voted as the results are stored anonymously.
yet
Nobody could ever find out what a particular voter has voted as the results are stored anonymously.
Voting Receipt - PASS Board of Directors Election 2014
Receipt code: T342
PASS Board of Directors Election: Kang; Kodos
Turkish delight or lokum (Turkish: Türk lokumu) is a family of confections based on a gel of starch and sugar. Premium varieties consist largely of chopped dates, pistachios, and hazelnuts or walnuts bound by the gel; traditional varieties are mostly gel, generally flavored with rosewater, mastic, Bergamot orange, or lemon. The confection is often packaged and eaten in small cubes dusted with icing sugar, copra, or powdered cream of tartar, to prevent clinging. Other common flavors include cinnamon and mint. In the production process, soapwort may be used as an emulsifying additive.
== History... ==
Glad we are all in agreement. That, aero and ... some other English sweet were things that I'd rather gargle with a beehive than ever put in my mouth again
Crunchie is a brand of English chocolate bar with a honeycomb toffee sugar centre. It is made by Cadbury and was originally launched by J. S. Fry & Sons in 1929. Fry had merged with Cadbury in 1919 and Crunchie later became a Cadbury bar.
A similar chocolate bar called the Violet Crumble competes in Australia manufactured by Nestlé.
== Size and variations ==
The Crunchie is sold in several sizes, ranging from "snack size" – a small rectangle – through to "king size". The most common portion is a single-serve bar, about 1 inch wide by about 7 inches long, and about 3/4 of an inch deep.
In the late...
Wispa is a brand of chocolate bar manufactured by Cadbury UK. The bar was launched in 1981 as a trial version in North East England and with its success it was introduced nationally in 1983. It was seen as a competitor to Rowntree's Aero (now owned by Nestlé). In 2003, as part of a relaunch of the Cadbury Dairy Milk brand, the Wispa brand was discontinued and the product relaunched as "Dairy Milk Bubbly". As part of the relaunch, the product was reshaped as a standard moulded bar (similar to other 'Dairy Milk' products) instead of a whole-bar count-line. However, in 2007, helped by an internet...
@MikeFal probably because you included a URL. Twitter is stupid.
Post all the spam URLs you want to thousands of followers. Dare to send a URL to one single person who lets you DM them because they trust you? Hell noes.
With all due respect to Kishore's answer, that approach is valid if you're modifying the packages. Since you're using the import/export wizard, the more straight forward approach would be to check the Enable Identity Insert box on the Column Mappings tab.
In the Import Export Wizard, after selec...
Do people really run into this often enough? I mean, it's got to be hitting plenty of people for it to be one of my higher rated answers but it seems so basic
I'll be honest, I'm of two minds of voting. With all the stuff around the name change, I wonder if my vote will even make a difference in how I want PASS to develop
@MikeFal I know. I'm saying (a) it's stupid that an active update was required and (b) that they didn't make that requirement more prominent to you on your profile page.
Check with these options:
- Username and password information in your wp-config.php file is incorrect. Please check with PHPMyAdmin and correct it or reset it. Also make necessary changes in wp-config.php file.
- Make sure that you have typed correct host name in wp-config.php file.
- Your hostin...