|
|
-
I just read in a forum about a user who want to replikate a table, but the table doesn't have a PK. The table is pretty large, and having the table not available while adding the PK is undesireable. The table has a clustered index already, and there are...( read more) 
|
-
I recently read a discussion whether RPC events add overhead compared to just submitting text. I got curious and did some testing, which I want to share. Background, SQL events Using most APIs, if you just submit a query to SQL Server, you will get what...( read more) 
|
-
This blog is not about avoiding logging in using the sa login. Hopefully we all know about this, and work towards avoidning this practice. Instead I want to talk about using sa, but not to login (authenticate), but as owner for jobs and databases. I want...( read more) 
|
-
One of the first things I want to do when I look at a new SQL Server is to get an idea of space usage details for each database, including total space usage. For this I have been using my own sp_db_space_usage for a while now, so I decided to add it to...( read more) 
|
-
You might just not get what you think. I would be surprised if this hasn't been blogged already, but if so, it would be worth repeating. Here's the deal (example from a forum,, slightly re-worked): I want the values in one column to be unique, assuming...( read more) 
|
-
Ola has released a new version of his db maint scripts, which now includes support for striping as well as Red-Gate. Ola updates these scripts now and then, so it is worth cheking out his versions page: http://ola.hallengren.com/Versions.html Share this...( read more) 
|
-
"What exiting item or idea did you find?", you probably think... The answer is: SQL Server nostalgia. Some of you might know that in the very early years, there were three companies involved in releasing SQL Server on the "PC" platform. In addition to...( read more) 
|
-
Are you stupid, you might think... But stop and think for a while. Model is no different from other databases. And by default it is in full recovery model. So as soon as you do your first database backup (you do backup your system databases, right?) the...( read more) 
|
-
I just read a newgroup question whether doing SHRINKFILE with the EMPTYFILE option for the primary log file somehow cause ill effects. Shrinkfile for the ldf will not move any data (log records) or so. For an ldf file it is basically a preparation to...( read more) 
|
-
In what user context does a job run? I recently found myself in a forum discussion and gave my stock reply, later realizing that I haven't actually tested this for a long time (I used to demo this in class during 6.5 courses - when we actually had time...( read more) 
|
-
Say you want to change the preferred netlib connection order. Or add a server alias. You can do this using the "SQL Server Configuration Manager" program. But installing this on each client machine where you want to do the modification might not feel...( read more) 
|
-
Let's start with some background on forwarding pointers: Forwarding pointers in heaps can be a mess to get rid of. A forwarding pointer happens when you modify a row so that the row doesn't fit on the same page anymore. SQL Server moves the row to a new...( read more) 
|
-
To many, this is a non-issue, since SSIS is installed anyhow. But not everyody installs SSIS. I for instance prefer to keep my production systems as clean as possible and only have what I really need (a principle which is harder and harder to live after...( read more) 
|
-
Under some circumstances, autogrow for database files can be set to some 12000 percent. I think this is limited to SQL Server 2005 and for databases upgraded from SQL Server 2000 (I didn't bother to search - feel free to comment if you know). So, if you...( read more) 
|
-
|
|
|