Building The SQLSaturday Orlando Marketing Plan-Part 14
Quick notes today:
Event team likes first flyer (retro) better than the second one (doesn’t have enough why, doesn’t use space...
2014-05-28
447 reads
Microsoft Dynamics AX 2012 – Multiple Rows In Demand Forecast Table [FORECASTSALES] for each item
Why are there multiple rows for each item in the Demand Forecast Table in Microsoft Dynamics AX 2012? This is...
2014-05-28
759 reads
PASS 2014 NomCom Candidates Announced
Eleven candidates for the nomcom this year, details at http://www.sqlpass.org/Elections.aspx. The NomCom campaign will open on June 2 and close...
2014-05-28
636 reads
Who has the DAC open?
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,710 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one...
2014-05-28
37 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-05-28
385 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-06-04 (first published: 2014-05-28)
2,027 reads
NodeXL – Accessible Network Graph Analysis, part 3 (Twitter)
This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.
If you are interested,...
2014-05-27
386 reads
How Much Value Would a SQLSaturday Certificate of Completion Have?
Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two,...
2014-05-27
716 reads
Webcast Follow-Up: 5 SQL Server Indexing Myths
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-05-27
905 reads
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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