Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Saturday, December 2, 2017

Comic for 2017.12.02

RSSMix.com Mix ID 8239024
Comic for 2017.12.02
New Cyanide and Happiness Comic

The Appearance of the Flat File Wizard.

SQLServerCentral » Latest topics
The Appearance of the Flat File Wizard.
Comments posted to this topic are about the item [B]The Appearance of the Flat File Wizard.[/B]

db_denydatawriter and db_datareader roles

SQLServerCentral » Latest topics
db_denydatawriter and db_datareader roles
We are ending a server in 2008 R2, but the users still need to access patient records. Simply setting the database to read only prevents their login entirely.

Is there a way to globally set the db_denydatawriter role and the db_datareader role w

The Difference Between Rollup and Cube

SQLServerCentral » Latest topics
The Difference Between Rollup and Cube
Comments posted to this topic are about the item [B]The Difference Between Rollup and Cube[/B]

SSRS Subscription Requirement

SQLServerCentral » Latest topics
SSRS Subscription Requirement
SSRS Subscription Requirements:
Brief Information about the Reports
·        

Not Useless Features

SQLServerCentral » Latest topics
Not Useless Features
Comments posted to this topic are about the item [B]Not Useless Features[/B]

http://www.skincareantiaging.org/nivele-slimming-cream/

SQLServerCentral » Latest topics
http://www.skincareantiaging.org/nivele-slimming-cream/
Nivele slimming cream:Cola remove assists with the skin's restoration procedure, advancing upgrades in how subcutaneous fat is put away. It sp

Are the posted questions getting worse?

SQLServerCentral » Latest topics
Are the posted questions getting worse?
Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in charge of something who was asking how to take a database backup and restore it on another server. It seems like the general feeling of a lot

Query Help -

SQLServerCentral » Latest topics
Query Help -
I need some help with a query I am writing, please see below.  
On the left join I have the table name IndexValues-11, I need to insert the '11' based upon the month retrieved from the GETDATE()-5 variable.
Hope somebody could help

Today's Random Word!

SQLServerCentral » Latest topics
Today's Random Word!
HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene or a word running through your mind... Jump on that word... And. Post it here by it's thumbs! :hat: Quickly! Before it becomes a number!

Friday, December 1, 2017

http://www.skincareantiaging.org/nivele-slimming-cream/

SQLServerCentral » Latest topics
http://www.skincareantiaging.org/nivele-slimming-cream/
Nivele slimming cream:Cola remove assists with the skin's restoration procedure, advancing upgrades in how subcutaneous fat is put away. It sp

Are the posted questions getting worse?

SQLServerCentral » Latest topics
Are the posted questions getting worse?
Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in charge of something who was asking how to take a database backup and restore it on another server. It seems like the general feeling of a lot

insert if record does not exists or if exists and column is not null criteria

SQLServerCentral » Latest topics
insert if record does not exists or if exists and column is not null criteria
I have a need to only insert Emp_Info into Emptbl if the Emp_Info doesn't already exist, or if the Emp_Info does exist AND has a value in the Emp_His column. I used below merge statement, but I get an error "An action of type 'INSERT' is not allowed in t

How to resolve Multiple lookup operation in execution plan for same index

SQLServerCentral » Latest topics
How to resolve Multiple lookup operation in execution plan for same index
In a Query Block, We are using a table (CustomerOpenOrder) multiple time to join with other tables. In Execution plan, Lookup operation for that table is showing multiple times , attaching the complete query

Comic for 2017.12.01

RSSMix.com Mix ID 8239024
Comic for 2017.12.01
New Cyanide and Happiness Comic