Getting Information from a Database using Dynamic SQL
I ran across someone that was building a restore script to automated their restores. This person wanted their script to...
2013-05-20
973 reads
The many uses of CROSS APPLY
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...
2013-05-23 (first published: 2013-05-20)
21,586 reads
Azure does Powershell too
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...
2013-05-23 (first published: 2013-05-20)
1,947 reads
Last Weeks Top “Reading” Links #33
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-20
633 reads
SQL – SQL Server Script to Iterate through All SQL Instances – Example Transaction Log Shrinking
There are many ways to execute SQL’s or T-SQL’s across listed SQL Instances. Most of us might have faced and...
2013-05-20
1,874 reads
Per Member Per Month Per 1000 Calculations in MDX
In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...
2013-05-24 (first published: 2013-05-20)
4,169 reads
SQL Server – Show/Hide Results Pane in Management Studio 2012
In earlier version of SQL Server Management Studio (2005, 2008 and 2008 R2) you can show/hide results pane using keyboard...
2013-05-20
1,857 reads
SQLSaturday#200 PA Event Update!
With less
than two weeks to go until SQLSaturday#200 at 45
Liberty Blvd., Suite 210 Malvern, PA 19355, Malvern, PA, 19355 they're...
2013-05-20
1,792 reads
Indexes – Understanding basic types and their components
The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...
2013-05-18
1,462 reads
Software Design and Schizophrenic Windows 8 Part 2
I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and...
2013-05-17
1,173 reads
Blogs
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...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCU TEGAL Telp:0821°7555°651
Telp/Wa 628217555651 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa...
Kantor Resmi BCA KCU SALATIGA Telp:0817°825°533
Telp/Wa 62817825533 Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah 50711
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