SQL 2008 - Number2 Blog

SCCM Guru Webcast Q&A #4 - Memory Capacity Planning by jnelson

This is part of the blog series where I finish answering all the questions that came up during my SCCM Guru Webcast session. QUESTION: Often, we see SQL...

Filed under: SQL, SQL 2008, SCCM Guru, SCCM Guru Webcast, SQL Memory

SMS/ConfigMgr - SQL Function to Convert Integer8 (from Active Directory) to Datetime/Local Time by jnelson

INTEGER8... It's possible you're pulling a value from Active Directory for discovery like LastLogonTimeStamp which stores it's value as something...

Filed under: SQL, sql 2005, SQL 2008, Discovery, Datetime2, Integer8, Active Directory, Datetime

SQL for SMS/ConfigMgr Tip - Distribute data evenly from 1 SQL file to multiple SQL files by jnelson

BACKGROUND When you first install an application like SMS or ConfigManager, the underlying SQL database is sitting in one data file. Now, depending on...

Filed under: performance tips, emptyfile, add file, SQL 2008, dbcc shrinkfile, database files, alter database

Number2 Blog - myITforum

Search

Tags

News

Navigation

Archives

Browse by Tags

SCCM Guru Webcast Q&A #4 - Memory Capacity Planning by jnelson

SMS/ConfigMgr - SQL Function to Convert Integer8 (from Active Directory) to Datetime/Local Time by jnelson

SQL for SMS/ConfigMgr Tip - Distribute data evenly from 1 SQL file to multiple SQL files by jnelson