100th blog post
Unless you’ve entered “100th blog post” into your favourite search engine and clicked on pot luck (or whatever it is)...
2013-03-01
577 reads
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
936 reads
SQL Server Events in the UK – March 2013
Welcome to the first of what I plan to be a regular recurring theme. Right here I will list out...
2013-03-01
777 reads
Windows 8 – First Impressions on a Desktop
I bought a new (to me) desktop recently to replace my aging hardware. I’ve had a quad core machine, but...
2013-03-01
1,047 reads
Something for the Weekend – SQL Server Links 01/03/13
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server...
2013-03-01
1,081 reads
SQL BLOG: First Occurrence Of Character In a String
Scenario:
We need to find the first occurrence of character ie non numeric data in the string without using the built...
2013-03-01
2,809 reads
YYYYMM Math
I had a project recently where I had to do math on a number that represented a date, YYYYMM.
For example,...
2013-03-01
693 reads
Presentation Materials “A Function is a Function”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...
2013-02-28
1,282 reads
Insert multiple values sets into a table in one command
The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...
2013-02-28
3,461 reads
A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)
Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series...
2013-02-28
2,054 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers