Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
2008-12-18
456 reads
The exceptional talents of seasoned engineers and developers can never quite be rendered obscelete by technological wizardry. Phil Factor considered old-school intuition, and wonders if he's missed a trick.
2008-12-12
497 reads
Phil Factor talks a bit about the SQLServerCentral community and how we all get something different from it.
2008-11-28
145 reads
Phil wonders whether it is time to come up with clear 'best practice' guidelines to cover the use of undocumented routines, and ends up deciding it is a gray area.
2008-11-24
434 reads
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
2008-11-20
278 reads
/* Imagine that you have some names and addresses. You are anxious to look at the addresses that may be spurious....
2008-11-03
689 reads
Somehow, one is expected to be pleased that SQL Server 2005 is going to have another Service Pack. Why? For many DBAs, SQL Server 2005 is still a dangerous and radical upgrade. Phil Factor considers Microsoft's responsibilities...
2008-10-28
225 reads
SQL Server and Sybase are geared up
to send information to applications over two distinct channels, the results in
one channel that...
2008-10-20
928 reads
/*datafile used in the SQL */
DECLARE @String VARCHAR(MAX)
SELECT @String = 'When you are starting out to validate text input, perhaps to clean...
2008-10-09
1,124 reads
I wrote the prettifier specifically to help with posting SQL into blogs and forums. You can find it here http://extras.sqlservercentral.com/prettifier/prettifier.aspx...
2008-10-07
6,687 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah 52663
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