News

Community News

Little SQL Server Tricks: Empty Table and Reset Auto Increment Id
2/20/2018
From time to time I get my development database in a state where I need to get rid of all rows in a table. SQL Server offers two ways to do that: DELETE and TRUNCATE. When you need to remove all rows use TRUNCATE, it is the faster option: [crayon-5a8fcbba7b4cb422489603/] When this command completes the ...

Read moreLittle SQL Server Tricks: Empty Table and Reset Auto Increment Id

mehr
Weekend Reader 2018.06: Angular is changing …
2/18/2018
FakeItEasy Cheat Sheet for Moq Users
2/13/2018
I am currently learning the ins and outs of the FakeItEasy mocking framework. I know my way around Moq, a simple and easy to use framework for the same purpose. This cheat sheet has examples for the most common use cases and explains the differences to Moq.   Why use a mocking framework? A mocking ...

Read moreFakeItEasy Cheat Sheet for Moq Users

mehr
Little SQL Server Tricks: Aggregate Functions on Columns
2/6/2018
Aggregate functions (like Min(), Max(), Sum(), etc.) are often used to calculate values in a SELECT statement. Instead of loading all the data and calculate the values for yourself, you let the database give you the answer. That is a lot faster and requires less typing. Aggregate functions are mostly used on rows. But did ...

Read moreLittle SQL Server Tricks: Aggregate Functions on Columns

mehr
Weekend Reader: 2018.05
2/3/2018
Page:
[1]
2
3
4
5
6
7
18
19
20

Für die Forumaktivitäten und Termine werden wir vorläufig die Xing-Plattform nutzen. Nähere Informationen findest Du unter dnug-bern.