You should have explicitly inidicated NOT to replicate the sparse attribute during article creation. Here's a quote from BOL:

The replication of the SPARSE attribute is determined by a schema...

Here's a solution (though not the nicest thing to look at). A few notes, your "teacherid" field doesn't seem like much of an "id". Unless I'm completely missing...

Could be a result of bad parameter sniffing. Without more information as to what the stored procedure does, the calls that are made to it (i.e. parameters), and execution...

If you are looking to retrieve the max number of error log files, then run this query:

use master

go

declare @max_log_files int

exec xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer',

N'NumErrorLogs', @max_log_files output

select @max_log_files

Notice, this is stored...

A Buffer Cache Hit Ratio of 99%+ is a good thing. It means that the requested data pages are coming from memory, as opposed to having to be read...

Grant Fritchey (5/1/2012)

Andy Hyslop (5/1/2012)

At +12K points you must know the points...

A little research will go a long way on this one. Pretty basic PowerShell aspects:

1: Reading files: Get-Content Cmdlet

2: Executing queries: Getting Data out of SQL Server from Powershell[/url]

3:...

Run this query in your instance:

select *

from sys.databases

where name = 'YourDatabaseName'

Does that actually return a record? The error is clearly laid out: you don't have a database with...

If you are trying to get alerted when a deadlock happens, just create a SQL Server Agent Alert for Error number of 1205. That will notify you of a...

I recommend you read a little about it here on BOL. Basically fill factor is how much page space is left open upon index creation or rebuilding. When...

That all depends. What kind of data manipulation is there against the table? With a fill factor of 100, any insert of data will cause an initial page split...

Your end result demands more data, "issues". Let's use this example:

create table Invoice

(

InvoiceId int identity(1, 1) not null primary key clustered,

Vendor...

As Gail pointed out above a full backup is a backup of the entire database.

I recommend that you read up about different types of backups, what is included in them, and different strategies. It is far to easy to invest confidence in a...

Check the event log. It may give additional information as to what is happening. SSCM handles things a bit differently than the services snap-in.