|
|
|
|
Browse by Tags
-
As I have been walking around Disney World this week, my mind starts to wander to matters of database design. Sad, perhaps, but I will guess that most people who read this blog do the same much the same thing with whatever technology they are good at Read More...
|
-
I had quite a few comments out there that were unpublished. One person was particularly slighted and I am sending him a "sorry" gift. I was stuck in "writer rut" and forgot about the fact that comments have to be allowed Read More...
|
-
As I am easing back into real life from writing the book, I am in search of easy targets for blogging. My boss mentioned this blog over on Jeff Atwood's Coding Horror Blog and it got me thinking about commenting. His advice is to only comment Read More...
|
-
Say it isn't so. "It isn't so." Glenn Berry thinks so in his post here . When I read his post I thought I was going to really get into it with Conor's post here , called the Trouble with Triggers (a title which I had to post because I Read More...
|
-
Next week is Tech Ed Developers, and I will be there working at the OLTP demo station from: Tuesday 11:45 – 2:45 Wednesday 2:30 – 6:00 Thursday 11:45 – 2:45 Friday 11:45 – 2:45 All times Eastern Daylight Saving Time and a little Read More...
|
-
Ok, so I am writing about the kinds of things you can do with a sequence table, and I have built the table, I have the typical kinds of things planned (like splitting a string, and for the next section, loading a calendar table) but I wanted to do something Read More...
|
-
Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of my book (ok, maybe not completely anti- but that isn't the point,) when I found this blog: http://geekswithblogs.net/Sreeblog/articles/117576.aspx that basically Read More...
|
-
Ok, I admit it. Sometimes the least important things are the most fun. As I try to get my blog back up and kicking again after a few months of holiday fun coupled with some dreary personal life things (a death in the family and lots of sickness/busyness, Read More...
|
-
In 2005, rebuilding a table that was a heap (no clustered index) wasn't easy. You could copy it to a different table, or you could add a clustered index and then drop it. In 2008, this is a far easier thing to do. They have added to the ALTER TABLE command Read More...
|
-
Well, I am just discovering this feature, mostly because I never saw it demoed at any of the sessions I have attended so far on 2008. Not that it was kept particularly hidden, I have seen the title before, but I hadn't tried it out, or seen the depth Read More...
|
-
Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005. I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about Read More...
|
-
d Gives you information about any sessions that are using xml documents, including stats about the XML document and usage. You can also get the statements that were used to create the XML handle using sys.dm_exec_sql_text to get the sql. Type: Function Read More...
|
-
It isn't that I don't like a challenge, really it isn't. I like puzzles, mazes, Suduko, video games with challenging levels where I have to really think about a problem to solve it. So why don't I like poorly designed databases, where finding a value Read More...
|
-
(Edit: Was reading Adam's book tonight and discovered you can pass a plan handle to this object. Very interesting!) This dynamic management object returns the SQL that was saved when a query was executed. This is a very exciting and useful thing to have, Read More...
|
-
I have already given a rundown of most everything PASS here on my personal blog, including a series of posts with pictures too over the days of PASS ) but since this blog is all about things technical with SQL Server, I wanted to just rundown of some Read More...
|
|
|
|
|
|