(for those old and flatulent enough to remember The Comedy Company)
Alternatively, one is reminded of Top Gear's review of the Chevy Camaro (basically a rehashed HSV commodore with a different body). "They had to go the the Australians for a bit of sophistication".
@MarkStorey-Smith @Phil @billinkc Remember the discussion last night about my large data import getting increasingly slower with each query? I ran the import again with some logging on, take a look at the log - its f*cking weird!! dba.stackexchange.com/questions/53831/…
anyone else with any experience of MySQL doing this, let me know!
@DannyBeckett Could it be as simple as you've clustered on old_id but as there is no order to your inserts you have an exponentially increasing rate of fragmentation?
wait... let me check I understood you correctly. Not sure what you mean by "dumping the data to a heap", but I removed the KEY line from the CREATE TABLE statement, and then added the index via CREATE INDEX afterwards
I'm not a MySql guy but IIRC InnoDB will create the clustered on the primary key, same as SQL Server does. So to test dumping to a heap, don't define the PK
heh, " An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated. " Translation, "lots of stuff is broken. I quit." right?
(I think what's actually going on is that some parts of the Stack Exchange environment are out of memory based on the initial error I got.)
wanted to log into the chat and watch 'em work. Kind of relaxing for a SQL Server consultant to watch someone else at work ;-) Alas, I'm not already logged in over there so I can't
Häh? Normally you may have 1 CPU, 4 cores. But having more cpu's than cores - what did you do? Hit a core with a hammer and distribute the parts into multiple CPU slots? — TomTomOct 25 at 5:30
So, as a training exercise for my Junior Dev, I'm thinking about spinning up a SQL server box on Azure and breaking something. Then he has an hour to fix it. Any thoughts on something simple, but engaging?
@FreshPrinceOfSO I'm considering either making a bad view or misconfiguring something simple. Maybe fill up the disk with a transaction log, or mess up permissions. He's more of a databse dev but I don't mind him learning some basic DBA stuff. The goal is to give him high pressure training without the risk
@AaronBertrand Nice. I'll read more details later but I like what I scanned and what I see in the charts at least ;-)
@AaronBertrand Ended up being an absolutely amazing game to be at last night, eh? Felt bad for you guys at the half. Turns out you were a historic one :)
@MikeWalsh Yeah halftime sucked. But I turned to Souza and said "The 3rd quarter is ours. 27 points!" Sure enough, I wasn't far off - 21 points in the quarter, 7 more within 2 minutes of the 4th.
i'm done with professional sports. they bring out the worst in me and they're not even an accurate representation of me. also ... elway needs to admit his mistake and cut hillman/ball and pay moreno ('cept he's hurt now)
Apparently (according to Argenis) Microsoft trademarked "Windows PowerShell" but did not bother to trademark "PowerShell" - same kind of silliness that leads to them using "PowerPoint" with no space but "Power Pivot" needs to have a space.
@AaronBertrand the overall quality of officiating last night was awful for both teams. it's why i've actually decided to disconnect from it because it's no longer about sport, it seems.
actually ... it's been awful all season ... across the board.
@swasheck Seems like every time a non-call is made the announcers say "the officials just don't want to ever make it about them at a crucial point in the game"
overall the broncos didnt come out to play in the second half, got knocked around in the first few series of the 3rd quarter and couldnt recover. there were awful calls and nocalls against both teams at fairly crucial points in the game and a mistake by the broncos won it for the pats. sucks that it had to come down to that --- but that's coaching and del rio just lost his USC job.
Is SQL 2014 just really sneaky smart? I set up a database with Full recovery mode. I run a ton of updates to a few rows, but the log never grows beyond %65 usage
No, who cares? It's not like you're going to have another index with the same keys but different (or no) INCLUDE columns, and if you are, then fix that before you start getting anal about naming conventions.
Clarification This question is not about "avoiding the pain of downvotes", for which "learn not to care about them" is a perfectly
acceptable response. It's about whether/how one can make questions
truly neutral, so as to maximize the possibility that folks will be
open and responsive to...
what is the meaning of this line? Can any body help me? I have confusion on last 2 sign :''
why without this two sign browser make error? Thanks all.
isset($_POST['but'])? $_POST['but']:'';
I am writing this statement in MS ACCESS
SELECT tblTrades.Tick, Sum(tblBbgDivData.BBG_Div_Forecast) AS SumOfBBG_Div_Forecast, tblBbgDivData.Div_Declared_Date
FROM tblBbgDivData INNER JOIN tblTrades ON tblBbgDivData.Tick = tblTrades.Tick
GROUP BY tblTrades.Tick
HAVING (((tblBbgDivData.Div_Declare...
Hello I have a bit complicated (for me) issue that I need to solve. I have 2 SQL tables - Payments and Clients.
In table Clients I have few columns but most important are totalPaid and clientID.
In Payments there columns called clientID and amountPaid the issue is that there may be many record...
The original table (exactly the one that I am using .. with all commas brackets etc)
id attributes
1 123(red), 139(red), 123(white), 123(black), 139(white),
2 123(black), 139(white), 123(green),
32 223(blue), 223(red), 553(white), 123(black),
4 323(white), 139(red),
23 ...
I have a table
Table_1(id int,tablename varchar(max),createdDate datetime)
now let suppose there are 20 rows with id(1-20). one column "tablename" is present in the Table_1. since 20 rows are in Table_1 hence tablename contains 20 different names(name1,name2,...,name20). Now these names have t...
The premise of the question is just bad. You're basically asking:
How do I write the perfect question that will be invulnerable to down-votes?
The simple answer is: you can't. This is like asking how to always avoid traffic on your commute. It's just not possible. You can take all the back ...
I need to get the exact date time to SSRS, I noticed when I use a date field the milliseconds get cut off in SSRS so I was thinking about formatting a string. I could not find a convert option that match the output I needed
mm/dd/yyyy hh:mm:ss.nnn AM/PM
So I came up with this long formula
-- ...
I tried to address that in my answer. Likely they are writing a view and don't want to to bother a bunch of different reports with pesky formatting code. I get why you might want to centralize that sometimes (though in most cases I completely agree with you - stop formatting in SQL).
@FreshPrinceOfSO well actually it's a little better to do it in SSRS, since SQL Server is quicker at just doling out the native data. SSRS (and other client applications that are presenting the data) have to go row-by-row anyway. Not making SQL Server perform conversions at every row will be much better for you in the long run.
@FreshPrinceOfSO I have fixed the issue Aaron raised and yet you down voted anyway have you ever heard the story of that monkey who some how got hold of a match box, he endup putting the whole jungle on fire. if you know what i mean pal. take it easy mate — Muhammed Ali3 mins ago
I am very new in pivoting, and need your help ...
current table
A1 A2 A3 A4 A5 A6
-------------------------------------------
1 22 pre-sale 9 kk 88
2 31 pos-sale 4 yy 67
3 2 current-sale 1 hh 45
...
No it isnt duplicate of any answer, none of the answers used the approach I have used. Even your answer at that time had more code than my answer, Yes I did declare the variable and forgot to use it in the solution and I did over look the fact question had sql-server 2005 tag in it. so I did use the inline declaration but it was for only demo purpose Im sure user is not going to use a variable it will be used on some column. — Muhammed Ali4 mins ago
Of course he'll never delete it, regardless of what a dicksmack it makes him look like, because it currently earns him 8 rep
This is a simple join; no need for subselects or anything fancy. SQLFiddle here.
SELECT *
FROM tblOrders o
JOIN tblOrderLines l ON (l.orderID=o.orderID)
WHERE l.ProductCategory=10;
It's really important to understand joins when developing for a database.
Here's a pretty good introduction to...
I know this shouldn't affect me, but a user just accepted an answer that's identical to mine, and that was posted later..... sigh
I mean, I understand posting the a duplicated late answer, it has happened to me when I don't get a notification of a new answer. But I always check afterwards and I would definitely delete my answer if it doesn't bring anything new
The point is probably moot, because we'll be getting an all-new collider thingy soon, but in the meantime the "recent badges" output looks tiny and wrong:
At least my reason isn't spite. You still haven't even answered the question. They could assign the variable with your so much better inline table-valued function and still scratch their head wondering why it doesn't output anything. Grow the F up. — Aaron Bertrand6 secs ago
Can you please not set a bug to status-completed until it's deployed? It's great that you checked it in and everything, and thank you for that, but setting a bug to fixed before it's deployed is misleading to users. — Aaron Bertrand35 secs ago
In several scenarios, including at least one today, we have had bugs set to status-completed simply because the fix has been checked in. Just because the code portion has been completed does not mean the work is done, and this can be confusing for users who come across the same problem. Until the...
I am trying to run a stored procedure for a table as opposed to one row . I choose a stored procedure as I need to insert records into a table and do some updates.
This method seems to be hanging. I looked at the explain plan but I think something is wrong with my logic and it processes one recor...
@AaronBertrand It's funny because they (rightfully) tend to avoid marking Data Explorer bugs as status-completed until my patches have been pulled and actually deployed to the public instance.
I am quite happy to see other points of view, and I do so all the time. Still I expect an answer to actually ANSWER THE QUESTION and yours DOES NO SUCH THING. The user has asked where to get diesel gasoline for their monster truck, and you've told them they should drive a hybrid because they're much more efficient. — Aaron Bertrand7 secs ago
Well apparently people don't like my idea. shrug I still think there are two very distinct states of a "completed" bug that I shouldn't have to go grok revision numbers to discern.
Where I work, it's a little more sane. A bug is marked as fixed when it ships, not when it's checked in.
You shouldn't use stored procedure for the sake of stored procedures.
In this case I would use an inline table valued function (which act as a parameterized view) thus:
create function dbo.bcSymbol ( @bc decimal(18,15) )
returns table
AS
return
select fileSymbol AS bcSymbol
from fileNameGenera...
Perhaps you should put some butter or ice underneath them.
This should help them slide
Clarification This question is not about "avoiding the pain of downvotes", for which "learn not to care about them" is a perfectly
acceptable response. It's about whether/how one can make questions
truly neutral, so as to maximize the possibility that folks will be
open and responsive to...
what is the meaning of this line? Can any body help me? I have confusion on last 2 sign :''
why without this two sign browser make error? Thanks all.
isset($_POST['but'])? $_POST['but']:'';
Hello I have a bit complicated (for me) issue that I need to solve. I have 2 SQL tables - Payments and Clients.
In table Clients I have few columns but most important are totalPaid and clientID.
In Payments there columns called clientID and amountPaid the issue is that there may be many record...
The original table (exactly the one that I am using .. with all commas brackets etc)
id attributes
1 123(red), 139(red), 123(white), 123(black), 139(white),
2 123(black), 139(white), 123(green),
32 223(blue), 223(red), 553(white), 123(black),
4 323(white), 139(red),
23 ...
I have a table
Table_1(id int,tablename varchar(max),createdDate datetime)
now let suppose there are 20 rows with id(1-20). one column "tablename" is present in the Table_1. since 20 rows are in Table_1 hence tablename contains 20 different names(name1,name2,...,name20). Now these names have t...
I need to get the exact date time to SSRS, I noticed when I use a date field the milliseconds get cut off in SSRS so I was thinking about formatting a string. I could not find a convert option that match the output I needed
mm/dd/yyyy hh:mm:ss.nnn AM/PM
So I came up with this long formula
-- ...
DECLARE @Date DATETIME = GETDATE()
SELECT CONVERT(VARCHAR(10), GETDATE(), 101) + ' '
+ RIGHT(CONVERT(VARCHAR(26), GETDATE(), 109), 13)
Result
11/25/2013 7:44:23:330PM
Look at this reference page, has many different formats covered - http://www.sql-server-helper.com/sql-server-2008/sql-server-2008-date-format.aspx
I am very new in pivoting, and need your help ...
current table
A1 A2 A3 A4 A5 A6
-------------------------------------------
1 22 pre-sale 9 kk 88
2 31 pos-sale 4 yy 67
3 2 current-sale 1 hh 45
...
This is a simple join; no need for subselects or anything fancy. SQLFiddle here.
SELECT *
FROM tblOrders o
JOIN tblOrderLines l ON (l.orderID=o.orderID)
WHERE l.ProductCategory=10;
It's really important to understand joins when developing for a database.
Here's a pretty good introduction to...
Well, I'm honoured, obviously!
I've always wanted those ones...
(Firefox 25.0.1 on Windows XP SP3)
You shouldn't use stored procedure for the sake of stored procedures.
In this case I would use an inline table valued function (which act as a parameterized view) thus:
create function dbo.bcSymbol ( @bc decimal(18,15) )
returns table
AS
return
select fileSymbol AS bcSymbol
from fileNameGenera...
