CREATE TABLE [dbo].[Client](

[ID] [int] IDENTITY(100,1) NOT NULL,

[FirstName] [varchar](50) NULL,

[MiddleName] [varchar](50) NULL,

[LastName] [varchar](50) NULL,

[NationalID] [varchar](15) NULL,

[Address1] [varchar](50) NULL,

[Address2] [varchar](50) NULL,

[City] [varchar](50) NULL,

[State] [char](2) NULL,

[PostalCode] [char](10) NULL,

[BirthDate] [date] NULL,

[HomePhoneNumber] [char](10) NULL,

[WorkPhoneNumber] [char](10)...

CREATE TABLE [dbo].[Client](

[ID] [int] IDENTITY(100,1) NOT NULL,

[FirstName] [varchar](50) NULL,

[MiddleName] [varchar](50) NULL,

[LastName] [varchar](50) NULL,

[NationalID] [varchar](15) NULL,

[Address1] [varchar](50) NULL,

[Address2] [varchar](50) NULL,

[City] [varchar](50) NULL,

[State] [char](2) NULL,

[PostalCode] [char](10) NULL,

[BirthDate] [date] NULL,

[HomePhoneNumber] [char](10) NULL,

[WorkPhoneNumber] [char](10)...

I agree about the screen shots, don't know what happened during the upload to the site. Here's a link to a pdf.

Send me an email (private message) and I'll send you the rar, I couldn't find any way to upload a rar on the blog.

Thanks for all of the replies. I didn't intend to imply that the DMV's are populated from system views when I wrote:

"system views that support the DMVs" instead I...

Yes, I am sysadmin. I have to admit I've never seen an instance that wasn't populating the system views.

Not a comprehensive list by any means; however, this is where I start for server / instance:

Available Memory

Buffer Cache Hit Ratio

Page Life Expectancy

Page Reads per Second

Page Writes per Second

File system...

String manipulation is a basic and often used part of any programming language including TSQL. I'd recommend reading about collation as well as the String functions.

I have a similar situation where I need to separate dependent databases onto independent servers to increase performance. The queries have massive joins between the database's tables - I...

Use the merge command.

merge using

...

on

...

when matched then

...

when not matched then

...

very straightforward.

ROFL. No, don't shrink and, IMHO, don't reorganize unless you know the condition of the indexes. I have DBs that get 1M+ rows inserted / updated daily so...

Are you asking about rejuvenating your SQL Server development skills? Or, DBA skills. If development then grab a decent T-SQL book and start cranking out some code. I...

I use an SSIS package run at specified intervals by SSA to send me an email notice of the data and log file sizes for all DBs on all Servers....

For my 2008 R2 WinServers I configure with system managed option with the dump option selected to capture the complete dump. This configuration generally results in a pagefile of...

Check out this link: