Can you tell me the sql query to convert the datetime field from which current date to be updated to previous date and time part as 21:00:00:000 adjusted to GMT
I was asking this question about writing fast inline table valued function in sql server.
The code in the answer is working but I'm asking about that part :
It is clear to me that he wanted to create many numbers ( 1,1,1,1,1,...) and then turn them to sequential numbers (1,2,3,4,5,6....):
...
@swasheck Once, I had a cow-orker who was a bit of a sci-fi nut and wanted to know which camp I sat in (wars vs. trek). I don't think I have any particular preference now, but 7yo me was definitely a star wars fan. I even got second place in a lego competition with an X-wing and a Tie fighter, something like 25 years before Lego actually made kits for them. Uphill both ways etc.
However, I have since come up with an idea to offend both Star Wars and Star Trek fans. Someday when I have a bit of spare time I will get a star destroyer kit (and I'll cannabilise my Millenium Falcon, so there) and make up a Lego [Type-S](http://www.freelancetraveller.com/features/gallery/mag/types.html). If you're enough of a geek to actually know what a Type-S is then you just earned your nerd cred.
> Process ID 52 attempted to unlock a resource it does not own: OBJECT: 2:60:0 . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
No, I made the project in my other pc, then just used open project and opened the project. I got errors stating that someone else had made the project and it had problems with decrypting xml etc. So I changed the ProtectionLevel of the project and packages to DoNotSave, then received the errors above. Then I changed project protection in it's properties menu to EncryptSensitiveWithUserKey and removed all the "DTS:ProtectionLevel="X"" from the all the packages view code. Then every packages was set to EncryptSensitiveWithUserKey by itself. But I still get the error that they are not the same — F4LLCON4 mins ago
I noticed I was sinking in the mud so I got out a shovel and dug furiously
> SQL Server 2016, in preview this summer, takes a major leap forward with a database and analytics platform that provides breakthrough performance for mission-critical applications and deeper insights on any data across on-premises and cloud. Key capabilities include enhanced in-memory technologies with real-time operational analytics, new security and encryption technologies, built-in advanced analytics with the R language, and mobile BI for on-premises data.
> The new Stretch Database capability is an industry first that allows for cost-effective access to historical data by dynamically stretching data to Microsoft Azure.
> It is also integrating PolyBase, an existing Microsoft tool that lets you use SQL queries against large non-relational databases such as those stored with Hadoop. Previously, PolyBase was only integrated with SQL Server Parallel Data Warehouse edition.
@dezso And rightly so. PostgreSQL has been an innovator since it was first built in the 1980s. Quite a few features such as extension APIs and spatial indexes (to name a couple) got their start in it.
Oracle, DB/2, Informix, SQL Server and many others all follow in the footsteps of PostgreSQL.
This is, of course, because PostgreSQL actually started out life as a research system built precisely to develop those capabilities.
I have a query that the vendor will not change. The query takes 4 hours and of course slows down the entire application. Has anyone run into this?
Query Code Here
I've got some weird permission thing happening in SQL Server that I can't understand why. We've got a role that has access to 2 databases. In one of the DBs it has access to a proc that selects from the other DB. I'm trying to set up a new role with the same permission. I've granted the same execute permission to the new role but it is throwing an error that it cannot select from the other DB.
The old role doesn't have anything specifically granted to it in the 2nd database which is weird
@PaulWhite how do you go about getting information on undocumented things? i've noticed a peculiarity with sys.dm_db_stats_properties_internal but it's undocumented so i'm not sure how much traction i'd get with google.
@PaulWhite know what? i think it may have been an issue with the patch level. i'll do a bit more investigation. the particular peculiarities are that i get two partition_number = 1 for RANGE RIGHT partition functions ... and the modification_counter doesnt update when i update one partition. however, thats on CU5 ...
It really depends. 99 times out of 100 if I learn something like that from someone I'm bound by NDA not to share it - at least until it is announced or written about publicly by someone who is allowed to.
@swasheck In the specific case of the dbi blog, yes this happens: people are allowed to share stuff if asked, but it might never appear in official documentation for supportability reasons. To that extent, you have to (a) be lucky; and (b) have access to someone like that, for example via a paid support agreement.
OTOH there have been occasions in the past where people have shared stuff they should not have, and got into serious trouble for it.
@billinkc @OldLoanNbris assigned in precisely one place. There is a possibility of a missing assignment at the end, from @OldLoanArchiveLoanID but that would mean the function never worked correctly. Which is plausible, I grant you.
Another of my favourite things about functions. Advertised as 'making code more reusable', but in reality they never quite are, resulting in close-copies of dumb code in multiple dumb functions. </rant>
> get's // banana's
Someone needs to peer review your apostrophe usage
@Zane It certainly looks suitable for conversion to an in-line function.
I have a software call Kodak Trophy(database program).This program stores patient data with x-rays. Now it is giving an error saying that the database cannot be open. When I try to reindex a codebase error appears with the following error Error #:-210, Error #:94003.
Unrecognized or Invalid Fi...
I have a simple basic three tables on SQL Server database:
What is needed is to get the quantity available, without using joins or unions which is calculated:
Quantity Available = Items Opening Balance - Items Delivered +
Items Received
Any Ideas are welcome.
Assigning parameters to local variables to avoid sniffing was the standard workaround before OPTIMIZE FOR UNKNOWN and trace flag 4136 became available. OPTION (RECOMPILE) does not disable sniffing, it extends it to become parameter embedding. I know what you meant to say here, but it's still not what you actually ended up saying. — Paul White31 secs ago
@MaxVernon Assume it is an assignment question where the goal is to use subqueries.
"How do I shoot myself in the foot" is a slightly different question than "I am trying to shoot myself in the foot because I'd like to test out my body armor"
@bluefeet soooo, I got an email this past weekend from SE about the cm thingy, it says that they know that it has been months, but if people are still interested, that they resubmit an application
yeah, it means that the spanish SO could actually be close to exist....the weird thing is that I did submit an application again following the link they send, and got this automatic reply: "You have previously applied for this position. A new application has not been submitted."
@PaulWhite ... ugh ... i was wrong. patched everything to CU7 and the dmv is still providing strange results. it's like a RANGE RIGHT partition is throwing it for a loop
@RoyiNamir Ask him for details about the 'workaround'. Did he get it from an official source, or just something they tried once when SCOPE_IDENTITY had problems? It is NOT one of the official workarounds for that specific issue.
@RoyiNamir Not just better - the only sane one. Before its introduction in SQL Server 2005 triggers would probably be your only option (for multi-insert identities).
Paul - no , he didnt get it from any source. he's just stubborn and can't get the fact that he might be wrong.(he's not a dba - jsut a c# programmer which knows sql)
Can you tell me the sql query to convert the datetime field from which current date to be updated to previous date and time part as 21:00:00:000 adjusted to GMT
I was asking this question about writing fast inline table valued function in sql server.
The code in the answer is working but I'm asking about that part :
It is clear to me that he wanted to create many numbers ( 1,1,1,1,1,...) and then turn them to sequential numbers (1,2,3,4,5,6....):
...
I have a query that the vendor will not change. The query takes 4 hours and of course slows down the entire application. Has anyone run into this?
Query Code Here
I have a software call Kodak Trophy(database program).This program stores patient data with x-rays. Now it is giving an error saying that the database cannot be open. When I try to reindex a codebase error appears with the following error Error #:-210, Error #:94003.
Unrecognized or Invalid Fi...
I have a simple basic three tables on SQL Server database:
What is needed is to get the quantity available, without using joins or unions which is calculated:
Quantity Available = Items Opening Balance - Items Delivered +
Items Received
Any Ideas are welcome.
