DBA Question of the Day: Statistic
http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics? We could get down and dirty of...
2012-10-26
1,076 reads
http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics? We could get down and dirty of...
2012-10-26
1,076 reads
Over the past few years, I have used Windows Live Writer to create my blog entries on WordPress. Given the...
2012-10-26
2,795 reads
I have been setting up multi instance database mirroring for the last couple of days along with some other DR...
2012-10-26
665 reads
I know I focus on community, SQL Server, professional development and process. But you need to do other stuff occasionally...
2012-10-26
737 reads
As most of us are aware, each instance of SSAS 2012 may be run in either tabular or multidimensional mode (and...
2012-10-26
3,766 reads
Hey everyone,
I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat...
2012-10-26
811 reads
My first training course from Pluralsight, Understanding Server Hardware has just gone live. It is listed in the SQL Server...
2012-10-26
1,502 reads
The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be...
2012-10-26
3,243 reads
When I used to work in an office I had a stack of flash cards and occasionally I'd grab a...
2012-10-25
828 reads
PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against...
2012-10-25
2,899 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. 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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers