SSIS For Loop Skip Files
When running a For Each Loop through a set of files, sometimes you will have specific files that you do...
2013-12-30 (first published: 2013-12-23)
2,701 reads
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
105 reads
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
263 reads
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-31 (first published: 2013-12-23)
6,047 reads
Google IQ Test
Friday (Dec 20, 2013) the Google Doodle was a crossword puzzle. I was curious so I clicked and yes, it...
2013-12-23
718 reads
Being a Better IT Pro - Grammar
In my IT career, one of the things I have found that sets me apart is my ability to write....
2013-12-27 (first published: 2013-12-23)
16,513 reads
Can Your Database Survive A Bus? Final Training Giveaway!: Day 11
This is the final training give away for a free month of Pluralsight! A comment on this post gets your...
2013-12-23
479 reads
Android is better than iOS
Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are...
2013-12-20
1,140 reads
Reblog: December 13 to December 19
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-20
876 reads
Assign SQL Service Account with Group Policy
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer...
2013-12-20
6,869 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
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