well, there is a few contributions here on SSC that does some of what you are after and much, much more:

http://www.sqlservercentral.com/search/?q=database+documentation&t=s&sort=relevance

one of the four links for "Comprehensive Database Documentation" is...

you have to rebuild all the indexes on the table, including the clustered index i believe in order to free the space to the database again.

not enough information for us to offer more than vague things to check.

performance tuning is a wide subject, and the tiny bit you gave us so far isn't enough to...

the ACE drivers are required for a SQL server 64 bit version to...

i've heard the data dictionary as being the Extended Properties comments that are potentially included in a database to describe objects/tables /columns, but only if someone has gone to...

you have to change your query to query first from a Calendar table of some sort, which contains all possible dates.

then your CTE left joins to that Calendar table.

with that...

in the procedure itself, do you have something like RETURN @MyDateValue

the return of a stored procedure only can return an integer, and it typically means success(0) or failure(non zero) ,...

since it's happening on the server itself(local machine), look at the running processes, and see if there's an additional application or scheduled task or something that is running/trying to connect...

there is some support for patterns/regular expressions in SQL

this does what you are asking, i think. one expression tests exactly ten characters, the other test the first ten characters

WITH mySampleData(val)

AS

(

SELECT...

Stan for the portion where you stick the image into a table, you can do it via a CLR function;

the CLR would look like this:

[Microsoft.SqlServer.Server.SqlFunction()]

public static SqlBytes CLR_GetFileImage(SqlString RetailerId)

{

try...

my first guess is that the table is a HEAP.

if the table is a HEAP (meaning it does not have a clustered index) when individual rows are deleted from the...

the function found at the end of this article is very highly rated among my peers here on SSC:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

select * from table

where numberColumn in

(SELECT Item FROM dbo.DelimitedSplit8K(@x,',')

it looks like not in Parallel Data Warehouse 2008, no sequences, sorry.

they are appear to available in Parallel Data Warehouse2012

Sequences were introduced in SQL server 2012, and each PDW...

this can be a little misleading, especially when it comes ot using sp_helpprotect.

that procedure lists the objects that the public role,(in this specific example) can see,

if you look at the...

i'm lost in the terminology here: what's "the internal email field"?

my first guess would be...