Does anyone know what `Non-yeilding IOCP Listener' indicates?
On of our SQL Servers just had a bugcheck dump:
=====================================================================
BugCheck Dump ...
There is no justice in this world. My "midnight" for SO is 8:00 PM. This guy accepted my answer about 14 seconds too late to give me another notch toward legendary:
@MaxVernon sorry, I've been lucky enough to avoid that one to date.
I have a column that I would like to update only if the value I pass in to a stored procedure is different than the value in the column. It happens to be an NVARCHAR(255) column, if that matters.
What are the pros and cons of writing this value every time? What are the pros and cons of checking ...
Since the stated case (a single column) is obviously easy to avoid (use a where clause), I immediately came to the conclusion that we must be talking about updating multiple columns but only writing to the columns where values have actually changed.
I'm not confident I've guessed correctly, but if I haven't, the question seems far too simplistic to me.
I want to get range ranking from a table using mysql query.
the table is like this,
+------------+------+
| first_name | age |
+------------+------+
| Kathy | 2 |
| Jane | 1 |
| Nick | 3 |
| Bob | 5 |
| Anne | 4 |
| Jack | 6 |
| Bill ...
-1 since you have shown no evidence of searching the documentation, or Google etc, for the answer. A more precise question would be helpful. If you've seen these operators in a query it would be helpful to post the query. — Max Vernon6 hours ago
@MaxVernon thanks for making the effort with helpful comments like this
I am working on updating our website's product database. It’s built in MySQL but this is more of a general database design pattern question.
I’m planning on switching to a Supertype/Subtype pattern. Our current/previous database is mainly a single table that has data on a single type of produc...
I personally would use a model similar to the following:
The product table would be pretty basic, your main product details:
create table product
(
part_number int, (PK)
name varchar(10),
price int
);
insert into product values
(1, 'product1', 50),
(2, 'product2', 95.99);
A product_attr...
Well, you can force nested loops by using OPTION(LOOP JOIN) however, I would advise using OPTION(LOOP JOIN, MERGE JOIN) this is working with the optimiser rather than against it and is saying do what you want as long as its not a hash match.
But I would also dig a little deeper. With the IN clau...
@AaronBertrand - So, the DATETIME style that you are using on your answer (22) is not listed here (msdn.microsoft.com/en-us/library/ms187928.aspx), I may have to use your guide from now on.
I am new to SQL, so please bear with me.
I am working with two tables that do not have common fields. I am trying to create simple hierarchy based on the two tables that look like this:
Table 1.
Cul 1 Cul 2
==============
S10000 Name
S20000 Name 1
S30000 Name 2
S40000 Name 3
...
In SQL Server NOT EXISTS shows up in the plan as an ANTI SEMIJOIN and is just another (efficient) join type. The plan for the outer join is null can be much worse as sometimes it outer joins everything then has a separate filter to remove nulls. Example of that here — Martin Smith2 mins ago
I have a sql server database with a time column which can only be filled with the text am or pm and im having trouble finding a constraint that would allow me to do this.
Many thanks in advance.
@bluefeet it's deteriorating rapidly. the collective intelligence is asymptotically approaching 0 even though the number of questions, answers, and words in general are skyrocketing
I hate it when an answer I am commenting on just disappears from underneath me.
I think you all scared Left Join + Filter away!
"It depends™: both NOT EXISTS and OUTER JOIN are logical, and performance depends on the physical plan operators and other details. Trying alternative SQL syntax is a valid approach."
This guy has edited his crappy PHP code 15 times. Sadly the revision only shows 2 updates because of the grace period. It's so hard to explain a moving target to these PHP kiddies:
I tried this way:
$result = odbc_exec($connection, 'SELECT id FROM MyTable WHERE id = @@Identity');
but it gives me
syntax error: unexpected T_VARIABLE
edit: here's complete logic thanks to your help:
$result = odbc_exec($connection, 'INSERT data into the table;SELECT SCOPE_IDENTITY() A...
@ypercube I dunno. When I put in my blog that this made MySQL unsafe for multiple applications to write to the same relations, the only responses I got from MySQL users were "multiple apps writing to the same relations? Are you crazy?"
I suspect someone has probably asked
I doubt that Oracle would really want MySQL to grow out of its 1 app 1 db role though :-P
(it would be interesting to see if this ever happens in Percona or Drizzle though)
1) Create a sound-alike name 2) Get sued by Microsoft 3) Countersue attacking the trademark as invalid, and alleging anti-competitive behavior 4) Make them pay you to drop the countersuit! Profit! Hey, worked for Lindows.....
Yes you can determine any escape character you wish, using the keyword ESCAPE followed by the character you wish. For example you can do this:
like '%unscaped string\%' ESCAPE '\'
@swasheck should be pretty trivial. Unless it's 10,000 spaghetti-code ASP pages (which I've seen first-hand).
@swasheck every single page had its own header set of functions with all of the connection information, access methods etc. hard-coded. "What's an include file?"
I'm tuning a query and have discovered some behavior I'm not clear about.
If I remove the WHERE IN clause the query runs in 3 seconds instead of 3 minutes.
There only 7 rows returned in the result since there are only 7 items in the IN clause.
Thinking this was a bit odd, I started trying ...
maybe a dumb question but I have been told that things run faster if you create a parameter with the date in it, instead of calculating the date in the query. I am referencing this question:
I have a Delete Query that each day needs to run deleteing any data that is greater than 7 days old which is about 6 Million Records.
My table should only store data for the last 7 days.
Here is the query I am running:
DELETE FROM [tblTSS_DataCollection]
Where [DatapointDate] < DATEADD(D, ...
Wow, I think they need to up the rep threshold for answering a question, or making it so that you must have earned x rep on a specific tag before you can answer there.
You can consider the following way :
-- store values in a temp table
SELECT * INTO #TEMP
FROM [tblTSS_DataCollection]
Where [DatapointDate] >= DATEADD(D, -7, GETDATE())
--truncate the old table
truncate table [tblTSS_DataCollection]
--insert values from temp table
insert into [tblTSS_DataC...
I have a query like this on Sql Server 2008:
DECLARE @START_DATE DATETIME
SET @START_DATE = GETDATE()
SELECT * FROM MY_TABLE
WHERE TRANSACTION_DATE_TIME > DATEADD(MINUTE, -1440, @START_DATE)
In the select query that you see above, does SqlServer optimize the query in order to not calculate...
Avoid inline query what ever using in inline use it is stored procedure
avoid cross joins
in the stored procedure you can do union all queries written it will very simple if you stored procedures
i have read the answer multiple times and I am still shaking my head
yeah ... no good. i would say it doesnt even have to be rep-based, but until the answer sees the light of day (read: SOE google), it should be approved/committed by the community.
I've also wondered - if I've exceeded my rep cap for the day, I should get some free down-votes. Once I've hit my rep cap, if I down-vote a question and then get an up-vote, the down-vote is free. If it happens in the opposite order, the down-vote costs me 1 rep. I don't care about the 1 rep, but the calculation for today should not care about the order of things that happened just before midnight.
...or whether a down-vote happened before or after the last up-vote.
In all honestly, I don't give a crap about the 1 or 2 rep I end up losing in those cases. I just like my rep to be an even number because I'm anal retentive.
@Aaron Bertrand - I wrote 'can consider', not 'this is a best solution'. I don't know why are you sure that 'data for last week less' is a 'narrow scenario', it isn't clear from the question. — Grisha1 min ago
Not something I'm going to whip up for a StackOverflow answer for a guy who doesn't know why the second column in his index doesn't help speed up a delete. :-)
@swasheck I would give 5000 rep to have Chrome working again on my Mac. Either the 10.8.2 update broke it or the Xcode update broke it thoroughly. OSX just feels like Windows 95 all over again these days. This is a Mac Mini - there's nothing special on it which should be "incompatible".
@swasheck I mainly just use it for Chrome and basic stuff that I want to just be reliable - web, viewing documents, email, printing PDFs etc. Thinking of getting a Chromebox for that job instead. More and more disappointed with Apple.
@swasheck Summer 2009, I think - I upgraded it to 8GB and it was doing great. Held off until Mountain Lion and it was doing fine until 10.8.2 update last night. Everything seems to be fine on it except Chrome.
@swasheck I've temporarily switched to Firefox. FF used to be such a memory hog I stopped using it. But I do rely on Chrome plug-ins like Google Voice etc to give me a lot of little shortcuts.
hello. ( sql server - bak file). if I set complex permissions to my datqabase to users and I backup this database into 1.bak. now lets say this bak file gets to john's hands. if john , opens it by restore to his own computer - will he have full access to everything ?
(ofcourse - john is an administrator in his own computer)
@AaronBertrand in this case, would it be any faster to find the index ID value for the max value you want to delete/keep (the split point in other words) and then just delete where ID less than found ID?
@RoyiNamir if you're able to acquire a non-password-protected full backup of the database (sort of thing is kept to automated systems with encrypted systems and automated passwords specifically to keep people from having copies) then you're a) inside the firewall, b) inside the network, and c) have full trusted permissions. (even if you've socially engineered or hacked)
At that point, why shouldn't you have full access to the data?
Now, if your question is how do you prevent that ... we can help with that, but it's hard.
(as all good security is)
What you can do instead is to set encrypted backups
That is actually a complicated question. And because it will help someone in the future, let's go ahead and move to a for-real Q on Database Administrators
Before you post a Q, however, let's review what you need:
Start with "So I was asking in chat [link to conversation] about how secure backup files are. I'm told that if an attacker has access to the .bak file unencrypted that they can have access to the data. So what if we used [code from above], would they still be able to access the data if the [continue from what you were just asking]"
@RoyiNamir If you have access to a bak file that is NOT encrypted, you can access everything in it. If it contains encrypted data, you'll need the certificate that was used to encrypt, which won't be in the backup file.
So I was asking in chat http://chat.stackexchange.com/rooms/179/the-heap about how secure backup files are.
I'm told that if an attacker has access to the .bak file unencrypted that they can have access to the data. So what if we used
OPEN SYMMETRIC KEY MySymetricKey DECRYPTION
BY CERTIFICATE...
Does anyone know what `Non-yeilding IOCP Listener' indicates?
On of our SQL Servers just had a bugcheck dump:
=====================================================================
BugCheck Dump ...
I want to get range ranking from a table using mysql query.
the table is like this,
+------------+------+
| first_name | age |
+------------+------+
| Kathy | 2 |
| Jane | 1 |
| Nick | 3 |
| Bob | 5 |
| Anne | 4 |
| Jack | 6 |
| Bill ...
Tim Post and his moderator issue M2A1-7 flamethrower...Burnnnnnn!
I am working on updating our website's product database. It’s built in MySQL but this is more of a general database design pattern question.
I’m planning on switching to a Supertype/Subtype pattern. Our current/previous database is mainly a single table that has data on a single type of produc...
I personally would use a model similar to the following:
The product table would be pretty basic, your main product details:
create table product
(
part_number int, (PK)
name varchar(10),
price int
);
insert into product values
(1, 'product1', 50),
(2, 'product2', 95.99);
A product_attr...
You could read the documentation?
I am new to SQL, so please bear with me.
I am working with two tables that do not have common fields. I am trying to create simple hierarchy based on the two tables that look like this:
Table 1.
Cul 1 Cul 2
==============
S10000 Name
S20000 Name 1
S30000 Name 2
S40000 Name 3
...
I have a sql server database with a time column which can only be filled with the text am or pm and im having trouble finding a constraint that would allow me to do this.
Many thanks in advance.
I tried this way:
$result = odbc_exec($connection, 'SELECT id FROM MyTable WHERE id = @@Identity');
but it gives me
syntax error: unexpected T_VARIABLE
edit: here's complete logic thanks to your help:
$result = odbc_exec($connection, 'INSERT data into the table;SELECT SCOPE_IDENTITY() A...
Yes you can determine any escape character you wish, using the keyword ESCAPE followed by the character you wish. For example you can do this:
like '%unscaped string\%' ESCAPE '\'
I'm tuning a query and have discovered some behavior I'm not clear about.
If I remove the WHERE IN clause the query runs in 3 seconds instead of 3 minutes.
There only 7 rows returned in the result since there are only 7 items in the IN clause.
Thinking this was a bit odd, I started trying ...
I have a Delete Query that each day needs to run deleteing any data that is greater than 7 days old which is about 6 Million Records.
My table should only store data for the last 7 days.
Here is the query I am running:
DELETE FROM [tblTSS_DataCollection]
Where [DatapointDate] < DATEADD(D, ...
You can consider the following way :
-- store values in a temp table
SELECT * INTO #TEMP
FROM [tblTSS_DataCollection]
Where [DatapointDate] >= DATEADD(D, -7, GETDATE())
--truncate the old table
truncate table [tblTSS_DataCollection]
--insert values from temp table
insert into [tblTSS_DataC...
I have a query like this on Sql Server 2008:
DECLARE @START_DATE DATETIME
SET @START_DATE = GETDATE()
SELECT * FROM MY_TABLE
WHERE TRANSACTION_DATE_TIME > DATEADD(MINUTE, -1440, @START_DATE)
In the select query that you see above, does SqlServer optimize the query in order to not calculate...
Avoid inline query what ever using in inline use it is stored procedure
avoid cross joins
in the stored procedure you can do union all queries written it will very simple if you stored procedures
So I was asking in chat http://chat.stackexchange.com/rooms/179/the-heap about how secure backup files are.
I'm told that if an attacker has access to the .bak file unencrypted that they can have access to the data. So what if we used
OPEN SYMMETRIC KEY MySymetricKey DECRYPTION
BY CERTIFICATE...
