Identity Insert and Table Variables – CONNECT issue
I was running some code the other day and was surprised by the result.
DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))
INSERT...
2012-08-03
2,758 reads
Who’s Responsible
This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I...
2012-08-03
898 reads
SQL Saturday US Map
Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL...
2012-08-03
1,570 reads
SQLSailor is exploring(Part5) – SQLDatabase Dashboard on Windows Azure
Well, that is one impressive dashboard of Audi RS4! It gives huge amount of flexibility for the driver to control...
2012-08-03
720 reads
When Things That Are Supposed to Protect You Try to Kill You
This past week I was presented with a very unique issue. A call came in with a production issue on...
2012-08-03
771 reads
Notes to a DBA who wishes to know more
I just sent this off to a fellow DBA who wanted some resources. You may also be one of those,...
2012-08-02
997 reads
SQL Server : Fixing the Orphaned Users
In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...
2012-08-02
1,458 reads
SQL Server:Finding the Orphaned Users
Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...
2012-08-02
1,731 reads
Creating and Managing User-Defined Roles in SQL Server 2012
SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference...
2012-08-02
2,886 reads
Startup Jobs
Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...
2012-08-08 (first published: 2012-08-02)
3,359 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