I know this subject has been discussed at length (I have read lots of posts here and all over the web) and I don't like to flog a dead horse but I have a question about a more specific aspect of Integer ID vs GUID:
I am writing out a schema which is going to have a tagging ability similar in use...
When I am trying login in phpgpadmin, always shows login failed, yesterday (and in past days) phppgadmin was working good, but now I am can't login.
If use same username and password via php code, it connects to postgreSQL DB succesfully, but in phppgadmin can't login.
What may causes this prob...
We added XML indexes to two tables that are pretty much identical
it works perfectly in DEV
in QC, when we query either of those views we get: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
I'd say SP2 + SP2 CU6. You can check all 6 CUs for references to fixes to severe errors, but note that not all fixes are publicly documented (depends on who reported/found them and what impact they have).
I have got table person which have got 2 triggers (if data is inserted, triggers make update) all triggers are after insert later I insert information about events to other table and I get (Update, Update, Insert) but should be this (Insert, Update, Update) do you know why?
I have got problem w...
I'm stuck in this.
In my enviroment, i have tmg 2010 running which is feeding logs into sql server 2008 r2. I have siem solution which uses jdbc through views gets logs from Sql -server. This configuration has already been done; but somehow no logs are getting through; I think I'm missing someth...
so I got back from a month-long vacation last Thursday and got laid-off on Friday... bit of a bummer really but I'm going with "one door closes and another opens".
@AndriyM I am going to delete my old answer because nobody has upvoted it and my answer handles ties and consecutive ranking differently from the others. Thus, I am migrating that answer away from that old question. — RolandoMySQLDBA10 mins ago
@MaxVernon @AaronBertrand I was struggling with the pump at a gas station in Mississauga once; friendliest Canadian I've ever met helped me figure out what the 8 different hoses were for
@RolandoMySQLDBA why do you always think that because an answer hasn't been up-voted it should be deleted? Answers can still be useful to people - especially yours, since they're so detailed - including to people who come here anonymously or don't yet have enough reputation to vote. — Aaron Bertrand11 secs ago
When multiple entries have the same score, the next rank should not be consecutive. The next rank should be incremented by number of scores that share the same rank.
To display scores like that requires to rank variables
rank variable to display
rank variable to calculate
Here is a more stab...
i undeleted and upvoted, it's a good answer with lots of explanation
@AndriyM ideally you would concentrate all of the answers on a single post, instead of splintering them among several posts, even if in some cases it will take users an additional click to get any answers.
@AndriyM perhaps you're the only one so far who has identified them as actual dupes?
@AndriyM I realize both have rank in the title but I haven't examined the questions/answers nor do I know MySQL well enough to be sure they are dupes on first glance.
No, that is not correct. You can't index a computed column that isn't deterministic, though.
The problem with DATEPART (and nasty shorthand) is that it depends on DATEFIRST settings, which can't be guaranteed to be the same for every user of the system.
@FreshPrinceOfSO yes, because that you could populate once and make deterministic. Though you will have to test whether the join is actually more efficient than just running DATEPART inline.
@FreshPrinceOfSO an index might still be used, just likely won't be able to seek. Still an index scan can be much more efficient than a table/CI scan if the index is covering. You should try it out. :-)
The only case I know of where a seek can still happen is applying CONVERT(DATE,) to a datetime column. Now forget I told you that because it's a dangerous exception to rely on (I don't believe it's documented and it could lead to assumptions about other scenarios that don't behave that way).
I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name:
Connecting to Integration Services service on the computer 'FooDB' failed with the following error: "Access is denied."
This error occurs when the c...
You would think that, but I can count on one hand the number of times I've used the SSMS integrated SSIS attachment thing after juggling a chainsaw and still have fingers left over
Plus, clusters make the things I know go out the window. They're voodoo
now it gathered 2 more downvotes. I wonder if the right way to go would be to contact a mod so you can delete it. @JNK can mods strip the accepted mark from an answer?, what's the right thing to do in this case?
@ypercube yeah a flag has already been declined. I'd say ypercube is right - if the OP unaccepts you can take there of the problem without bothering the mods again. :-)
> "President Bush said to all of us: 'I'm driven with a mission from God. God would tell me, "George, go and fight those terrorists in Afghanistan." And I did, and then God would tell me, "George, go and end the tyranny in Iraq ." And I did.
Hi I need to import about 4 million records into my DB. The file is a csv. I have tried MyAdminphp and it times out. Then i tried Razor SQL and it's way too slow. Any suggestions for handling this many iserts?
I have an error and I cannot find the reason for failing of this procedure. All I know it does something I have no clue about. Does anyone have an idea what is this about? :|
ALTER PROCEDURE [dbo].[updateAccountPersonJob]
@department nvarchar(50),
@description nvarchar(50),
@personI...
Yes CUs are cumulative within a branch. SP doesn't always include the fixes from the most recent CUs for earlier branches (usually one or two) because of the testing time differences.
For example, many of the fixes in 2012 RTM CUs didn't make it into SP1 until CU1 or CU2.
Even though the SP was released after the CUs for RTM, the code was checked in long before, all the lead time spent on regression testing.
Usually they get those fixes in quite quickly. For SP1 I think CU1 was out within a week or two.
When multiple entries have the same score, the next rank should not be consecutive. The next rank should be incremented by number of scores that share the same rank.
To display scores like that requires to rank variables
rank variable to display
rank variable to calculate
Here is a more stab...
I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name:
Connecting to Integration Services service on the computer 'FooDB' failed with the following error: "Access is denied."
This error occurs when the c...
My answer is poopy and it smells really bad.
Hi I need to import about 4 million records into my DB. The file is a csv. I have tried MyAdminphp and it times out. Then i tried Razor SQL and it's way too slow. Any suggestions for handling this many iserts?
I have an error and I cannot find the reason for failing of this procedure. All I know it does something I have no clue about. Does anyone have an idea what is this about? :|
ALTER PROCEDURE [dbo].[updateAccountPersonJob]
@department nvarchar(50),
@description nvarchar(50),
@personI...
