This enhancement to the object_name function is so wonderfull for the T-Sql guru's under us: The object_name() function now accepts 2 arguments: the object_id as before and as a second argument the DATABASE_ID. Isn't this wonderfull? We can finally leave the current database context, without to play around with dynamic sql. Simply...
posted by
on
to
()
It was a wonderfull day, full of Kimberly Trip and Paul Randal sessions. I will make it short today as they put all the slides and scripts on there website SQLskills . So only some thoughts for today: - I always thought that the default fill factor at the server level was 90%. It turned out that it is a 100%. I have to review some...
posted by
on
to
()
Another interesting day, full information. Once I return and I find more time, I will work out some topics. For the moment I'll provide you today with some 2-sentence topics: - Sql Server 2005: on logging in to Sql Server 2005 and you are not using any encryption, Sql Server will encrypt your login & password automatically. I...
posted by
on
to
()
Today, some nice-to-know's - Sql Server 2005 SP3 (not known yet when it will come out) will probably contain an instruction to do an active checksum verification on all pages of a database - Sql Server 2008 CTP (November): * What concerns the features about Transparant Data Encryption in Sql Server 2008: Tempdb will (implicitly)...
posted by
on
to
()
As this is a technical blog I will not give a report of this night, so after only 4 hours in bed: What do I remember from yesterday? First half of the day, community work, nice conversations with other peers. And a lot of Belgians, we were 6 or 7! Last half of the day was more sql related. I missed the keynote so I went to Francois...
posted by
on
to
()