187 reputation
4
bio website schmitzit.com
location Denmark
age 38
visits member for 1 year, 6 months
seen Feb 14 at 6:42

Specialized in XenForo services.


Feb
14
awarded  Supporter
Feb
13
comment Why does query error with empty result set in SQL Server 2012?
@GordonLinoff Paul Randal just confirmed via Twitter that your reply was bang on.
Feb
13
comment Why does query error with empty result set in SQL Server 2012?
Great question :)
Feb
13
comment Why does query error with empty result set in SQL Server 2012?
The one guy who would know for sure (or if he doesn't, he'd be able to find out) would be @PaulRandal. Will try and get his attention to this Question.
Dec
1
comment How to install SQL Server 2008 R2
You'll need to provide some more information. What exacty do you think you installed? Which options? From where? Do you have a folder called Microsoft SQL Server in your Program Files folder? Did you reboot after installing? (Shouldn't be necessary, but usually a good idea).
May
10
comment Installation of SQL Server RAID 10 vs RAID 5
RAID 5 for C sounds like a waste of money. If it's for TempDB, then move that to it's separate RAID 10 partition if you can. Other than that, RAID 10, while more expensive, does offer better performance for relational systems with heavy WRITEs. Whether your case meets that is not something we could assess, but you can measure that.
Jan
11
comment SQL Server 2012 database backup successfully report but no backup file
Can you show the details of the maintenance plan, please? Some screenshots or something would help us assist you better.
Nov
28
answered limiting sql server backups inside .bak file
Nov
20
answered Error on SELECT - Primary filegroup is full
Oct
20
awarded  Autobiographer
Oct
18
comment Alter table on live production databases
@AlexKuznetsov - I read the article as saying that there's risks involved, but not as a discouragement. Anyway, I didn't link the article for the GUI bit, but as an indication of some of the operations that lead to an ALTER statement leading to the creation of a temporary table due to changes in the underlying data structure. I haven't tested whether the exact same thing applies when issuing the statement directly from T-SQL, but I would think the process is pretty similar and that SL Server does the legwork behind the scenes.
Oct
18
awarded  Editor
Oct
18
awarded  Teacher
Oct
18
comment Alter table on live production databases
@AlexKuznetsov - I figured the preceding line, as well as the link with some of the cases listed would clarify this does not always happen. I amended the sentence to better reflect this.
Oct
18
revised Alter table on live production databases
added 19 characters in body
Oct
18
answered Alter table on live production databases
Oct
14
answered Transaction Log file .ldf is too small
Oct
12
answered Backup audit database
Aug
3
answered How SQL server database reorganize memory