2018-08-09
848 reads
2018-08-09
848 reads
2016-06-07
1,402 reads
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!
2016-06-03 (first published: 2015-04-14)
25,763 reads
2014-11-24
2,001 reads
SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.
2015-05-01 (first published: 2012-01-19)
30,932 reads
Remi, Will this work without a table/index scan?where datediff(d, Getdate(), date_column) = 0
2005-04-14
Since they log OR the data are required to restore, I don't worry about this. dbcc will check this.
2004-10-19
Hey all,I'm testing a bunch of new logins, both SQL Sever and Windows authentication, that have been handed off to me. Want to be able to login with QA and then see the permissions that login has on the server.I can't remember/find how to check privileges for a login I'm using at the moment. sp_helpuser isn't it.much […]
2004-07-01
1 reads
Hi all, Can anyone help me in this. I have a database on the production server which has a recovery model set to Simple. Now I need to change the recovery model to Full in order to take an advantage of transaction log files for my log shipping. Now I know, I can easily change […]
2004-06-01
6 reads
quote: Yes, that's true but when you are in the middle of replying to a message, there is no way to tell who is logged in. It's kind of screwy when you are sharing a computer. hit CRTL+N (if you use IE) to create a new instance and look at it in the new instance. […]
2003-08-27
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers