Write more compact SQL Server code using new features
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
2018-12-06
3,690 reads
DROP
2018-11-05 (first published: 2018-10-22)
816 reads
How to find user who ran DROP or DELETE statements on your SQL Server Objects
Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information.
2013-12-12
6,938 reads
2009-09-24 (first published: 2009-09-15)
683 reads
2012-09-04 (first published: 2008-04-24)
1,132 reads
RE: Parameter syntax
BOL states: @local_variableIs the name of a variable of any type except cursor, text, ntext, or image. Variable names must begin with one at sign (@). Variable names must conform to the rules for identifiers. For more information, see Using Identifiers. Using Identifiers follows up with also stating the @ must be used. This is not […]
2005-05-06
RE: sortorder on varchar datatype column containing numeric values
Actually rereading the thread and the "best" advise here is to split numbers from strings into two columns. What you describe is indeed expected behaviour. There are, of course, workarounds possible to get what you expect. that's why I said, post sample data. But every workaround is a kludge at best.
2005-05-03
RE: DTS and/or job autorization, anyone?
Holdit,holdit,Are you telling me, that when I start a job via EM on my workstation it runs under MY securityaccount, and not under the SQLServerAgent account of the machine involved?! If this is so,I'm really flabbergasted!About the network-authorities: I don't know. Both services run under the Administrator accounts. But as I explained: another job addressing […]
2004-04-15
Alternatives to self-joins?
I have a small issue, but I cannot find a way out of it - any assistance with this would be great.We are implenting indexed views for a 'data warehouse' type arrangement. The problem is that many of our existing views incorporate self-joins which prevent me from creating indexes on them. These views have been […]
2004-03-10
212 reads
2003-06-26
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers