Skip to content

Igor Micev

My blog about SQL Server

Menu

Primary menu

  • Blog
  • About Me

Category Archives: SQL Server

SQL Server

SQL Server and Hyper-threading

Posted on December 20, 2016 by Igor Micev — No Comments ↓

This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of this post. Physical environments According to the official msdn references ([1], Continue reading SQL Server and Hyper-threading→

Posted in SQL Server | Tagged licensing | Leave a reply

SQL Server sample databases

Posted on February 24, 2014 by Igor Micev — No Comments ↓

Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have some of them on your local instance. 1. The AdventureWorks sample databases for SQL Server versions can be found on the Continue reading SQL Server sample databases→

Posted in SQL Server, Uncategorized | Tagged sample databases | Leave a reply

Primary Sidebar Widget Area

Recent Posts

  • Useful T-SQL queries and scripts to work in SQL Server
  • How to Write a Better T-SQL Code
  • Some New Cool Features in SSMS

Categories

  • .NET (3)
  • Configuration (6)
  • Database design (5)
  • Features (4)
  • Installation (4)
  • Maintenance (7)
  • Optimization (5)
  • Programming (5)
  • Scripts (4)
  • SQL Server (2)
  • SSMS (6)
  • T-SQL (13)
  • Technology (2)
  • Uncategorized (6)

Tags

C# clone CLR code-refactoring compression configuration constraints cpu CXPACKET dates EOMONTH extents foreign keys fragmentation functions hints and tips indexes JASON jobs jokes licensing master rebuild maxdop MCT mixed_page_allocation MVP powershell primary key query Regex reports report server sample databases script snapshot SQL Azure sql server ports stored procedures system databases tempdb temp tables

Subscribe via Email

Subscribe via Email

  • Twitter
  • Google Plus
  • Linkedin
  • RSS Feed
Copyright © 2023 Igor Micev. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up