SQL Server : Implementation of Table Valued Parameter (TVP)
Some time there will be situation in application , where a
grid is populated with data and user has option to edit...
2012-08-09 (first published: 2012-08-01)
6,360 reads
Prevent wiping out of SSAS partitions
There have been a few times when I have created SSAS partitions outside of BIDS using script code in an...
2012-08-01
1,033 reads
Set Up SQL Server Mirroring T-SQL Script
T-SQL Script to create a SQL Mirroring:-
The first thing you need to do when setting up Database Mirroring is perform...
2012-08-01
20,354 reads
Execution Plans … In the Cloud!
If you’re moving to a fully-fledged SQL database as part of Azure you may never even touch SQL Server Management...
2012-08-10 (first published: 2012-08-01)
2,739 reads
Deploying and processing SSAS cubes
In SSAS we build what’s known as a UDM, or Unified Dimensional Model, over the top of a database schema,...
2012-08-01
7,110 reads
Restores in SQL Server Analysis Services
“You’re only as good as your last restore”
I’ve no idea who originally said that – but it probably qualifies as DBA...
2012-08-01
1,061 reads
Fully Dynamic Search Conditions vs. SQL Injection
SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the most...
2012-08-01
675 reads
SQL Server Quickies – a new way to learn about SQL Server
We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies...
2012-08-01
505 reads
SQL Server Quickies – a new way to learn about SQL Server
We are all living in a fast moving world, especially in the IT industry. We have to
learn new technologies every...
2012-08-01
1,316 reads
Two New Cumulative Updates for SQL Server 2008
On July 17, Microsoft released two new Cumulative Updates for SQL Server 2008. The first cumulative update is SQL Server...
2012-08-01
963 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers