Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • My dummy projects
  • About

Category: Sql Server 2016

Posted on December 20, 2020December 22, 2020

Sql Server Instant File Initialization

Sql Server Instant File Initialization is a Sql Server option that, I have to admit, I didn’t know. Activating this option you can slightly improveRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on March 21, 2020May 3, 2020

Sql Server add constraint WITH NOCHECK

Good morning guys! Today I want to talk about a Sql Server feature that you could use when creating foreign key constraints: the WITH NOCHECKRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on March 10, 2020March 10, 2020

Get SQL Server version in T-SQL

Hi guys!! Today I want to share a simple but useful trick to show the version of your SQL Server. Just type the following command:Read more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on December 17, 2019

Get all referencing tables of a table in Sql Server

Today I want to talk about how to get all referencing tables of a Sql Server table. It is useful, for example, if you needRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on October 5, 2019

Sql Server: apply an aggregate function to fields values in a row

Did you ever need to apply an aggregate function to fields values in a row? It happened to me just few days ago… I willRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on September 15, 2019June 14, 2020

How to know who is blocking a query in Sql Server

It’s been a while since we last heard… The Dummy Programmer was really really busy and couldn’t write any post. But now I’m back toRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on June 25, 2019June 25, 2019

Improving SQL Server cursor performance

Hi everyone! Today I want to talk about a performance problem I had a few days ago using a SQL Server cursor. Imagine using a cursorRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on May 16, 2019May 20, 2019

Delete all rows from all tables in a Sql Server database

Delete all rows from all tables in a Sql Server database may not be an easy task. This because in a relational database you haveRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on April 12, 2019April 12, 2019

Search a string in stored procedures, functions and views in a SQL Server database

If you want to search a string in stored procedures, functions and views, maybe you can use some special tools. But, for instance, suppose thatRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on February 2, 2019

SQL Server LEN function return 0 passing a string with one space

Try to answer this riddle: What is the result of this SQL Server query: PRINT LEN(‘ ‘) I would answer 1, since I passed aRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment

Posts navigation

Older

Search

Subscribe to our newsletter

Categories

  • AJAX (1)
  • Android (1)
  • Apache (2)
  • ASP.NET (6)
  • ASP.NET MVC (3)
  • BCP (1)
  • Bitlocker (2)
  • C# (10)
  • CentOS (4)
  • CLR (1)
  • DNS (1)
  • Encryption (3)
  • Excel (2)
  • FuelPHP (2)
  • Google Chrome (1)
  • GSuite (1)
  • Imagick (2)
  • Linux (2)
  • MariaDB (2)
  • Mathematics (1)
  • MySql (4)
  • NPOI (1)
  • Office 365 (1)
  • Perl (1)
  • PHP (5)
  • Programming (1)
  • Remote desktop (1)
  • SFTP (2)
  • Sockets (3)
  • Sql Server (15)
  • Sql Server 2016 (11)
  • SSL (1)
  • Task scheduler (1)
  • Telerik ASP.NET AJAX (1)
  • The Dummy Programmer Chat (2)
  • Threading (4)
  • Tools (1)
  • TPL (3)
  • Ubuntu (1)
  • Virtualization software (3)
  • Visual Studio (1)
  • Web fonts (1)
  • Web programming (6)
  • Windows (12)
  • Windows 10 (14)
  • Windows Forms (1)
  • Windows Server (5)

Copyright © 2021 The Dummy Programmer

All Rights Reserved | Mega Blog by Theme Palace