I don’t often use SQL queries but sometimes I have to. And every time it’s the same – I use search engines to find documentation, especially about work with datetime fields. During these readings I found out at least 3 ways to select records with date I need.

(read more...)

It’s good to be dbowner in MS SQL server, but it’s easy to forget about permissions for other users. I created a procedure and tried to execute it from technical account. And I've got the error that user can not execute procedures. (read more...)

Field with autoincrement is very useful thing and it's often used in MySQL. In MSSQL you can also need to use this tool. There are two ways to do it. (read more...)

On test environment I have executed an SQL Server Integration Services Package and I’va got the error:
SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The component "Lookup My Cities" (64) cannot run on installed (64-bit) of Integration Services. It requires Standard Edition (64-bit) or higher. End Error

As it turned out, service SQL Server Integration Services wasn’t installed on the machine and I had to add it to SQL server features (Drawing 1). (read more...)

Transaction Log is a weak place in SQL server for HDD, especially if it’s a test area and you don’t make every day back up of your databases. While creating back up transaction logs are shrinking. (read more...)

There’s a table in SharePoint content database where all the events are written in case if audit is turned on. But SharePoint doesn’t display real-time statistic about users on site, it gives you statistic only on the next day. (read more...)

You need to make query like "SELECT * from tbl WHERE items IN ('item1', 'item2', 'item3', 'item4')" and you want to send items to IN clause as variable. It’s nice when, for example, you want to execute Stored procedure or, as in example below, use INSERT ... SELECT construction. Then you need to make a fint with quotes. (read more...)

The task is to select all the records where parent equal ‘1’ and parent of parent equal ‘1’ etc. Our datatable is:

(read more...)