My $200 Oops
My Nexus 7 tablet has grown on me, though I think it’s more about having a dedicated tablet than the...
2013-02-14
630 reads
SQL Server 2008 Statistics: What does a DBA need to know?
I’ve been looking into the behaviour of statistics in SQL Server 2008 – so I’d like to present an overview from...
2013-02-20 (first published: 2013-02-14)
7,126 reads
Upcoming Online Training for the Week of February 18, 2013
I used to compile a list of online training for the following week and posting it on Fridays. I stopped...
2013-02-14
1,017 reads
Microsoft Security Bulletin || Vulnerabilities in FAST Search Server 2010 || Remote Code Execution
Friends, Microsoft has release a security bulletin for a FAST Search for SharePoint 2010. PF below for more help.
Full Details...
2013-02-14
1,030 reads
Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies
Welcome to day 28 of my series 31 Days of Disaster Recovery. Today I want to talk about recovering SQL...
2013-02-22 (first published: 2013-02-14)
2,902 reads
Exploring Excel 2013 for BI Tip #2: Show Details
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-02-13
692 reads
SQLBits XI Agenda Announced
The agenda for the SQLBits event in May was announced today and after a quick look earlier today, it looks...
2013-02-13
640 reads
Slides for today’s PASS Virtualization Webinar Now Available
I had a great time in delivering the SQL PASS Virtualization virtual chapter session today on ‘Squeezing the most performance...
2013-02-13
625 reads
Running SQLIO with Multiple Files
Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files? Until a couple months...
2013-02-21 (first published: 2013-02-13)
2,535 reads
How to get list of all available parameter of .EXE file ?
Today, We discuss How to get list of all available parameter of .EXE file OR How to find list of...
2013-02-13
5,552 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...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
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