Learning a New Development Platform
This past week at work we have been having some in-depth training. The interesting thing is it hasn't been SQL...
2009-06-18
1,316 reads
Lynn Pettis
SSC, more than a Forum, it is a Community
I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent. So far, there haven't been a whole lot of votes, but those who have, have been unanimous in using SQLServerCentral.com and have indicated that there are...
2009-06-17
1,211 reads
SSC, more than a Forum, it is a Community
I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent. So far, there haven't been a...
2009-06-07
1,589 reads
My Latest Articles
A few weeks ago I mentioned my blog that I would have two articles published on sswug.org. Well, they have...
2009-06-04
1,556 reads
Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...
2009-05-12
1,958 reads
Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of...
2009-05-07
3,323 reads
When a Community Rallies!
I have been a bit lax these past few days, but I have been having a bit of a writers block not knowing what to write about. Well, I realized this evening there is something worth writing about, and it is happening right now on SQLServerCentral.com. An...
2009-05-07
1,496 reads
Published, Again!
I have written two new articles and they are going to be published, not on SSC but on SSWUG. I...
2009-05-02
1,275 reads
When a Community Rallies!
I have been a bit lax these past few days, but I have been having a bit of a writers...
2009-04-27
1,437 reads
Career Development and Training
I know I discussed this in an early post, but it seems to have reared its ugly head again. This...
2009-04-17
1,565 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
Txn log file is full. Error 9002
Hi All, Here is the scenario on of the test servers. The transaction log...
How to define data types
What are the things you consider when you create a new table and define...
What is the default data-type for columns made from an expression
In Microsoft SQL Server Management Studio 2014, when you execute the following statement: SELECT...
Ask SSC