139 reputation
5
bio website qr.cz
location in the middle of nowhere
age 35
visits member for 2 years, 2 months
seen 2 days ago
  • Delphi
  • MSSQL
  • Ex PHP, CSS, JS, Python

Jan
27
comment Why is % forbidden char in THROW message?
It is not true. You pass %s as FORMATMESSAGE parameter (because you join strings using plus) but you didn't specify any true parameters for replacing. You are calling: FORMATMESSAGE('Error value: %s', NULL, NULL, ... ...)
Dec
6
comment Why is % forbidden char in THROW message?
This is so sad. They gave us working Exceptions (finally!) but instantly broke it. Message parameters are gone and they even managed to keep some parameter-related code, just for fun.
Dec
5
comment Why is % forbidden char in THROW message?
@swasheck Really? I have only "Msg 50000, Level 16, State 1, Line 1", without message.
Dec
5
revised Why is % forbidden char in THROW message?
added 3 characters in body
Dec
5
awarded  Editor
Dec
5
revised Why is % forbidden char in THROW message?
deleted 36 characters in body
Dec
5
awarded  Student
Dec
5
asked Why is % forbidden char in THROW message?
Jun
18
awarded  Teacher
Jun
11
comment Difference Between SP with BEGIN/END and without BEGIN/END
BEGIN / END is optional, you can add them anywhere (without any IF, WHILE blocks...). I suggest do not use them in SP because you can add some test selects after (redundant) END and then alter procedure with them by mistake.
Jun
7
comment Update a table from a join
Yes, it is better to use alias. For avoiding possible deadlocks you can use dbo.GEMS_DEPARTMENT AS d WITH(XLOCK) hint.
Jun
2
answered How to see what is cached in memory in SQL server 2008?
May
30
comment Remove scientific notation from an XML column
SQL Fiddle, nice!
May
11
answered AlwaysOn Architecture - SQL Server 2012 for creating a dev environment?
May
11
comment AlwaysOn Architecture - SQL Server 2012 for creating a dev environment?
Upvoted "someone's shoulder to cry" :)
May
7
awarded  Supporter
May
4
comment Maximum memory setting in SQL Server
There is nice Report in SSMS about SQL server memory: blogs.msdn.com/b/buckwoody/archive/2007/10/17/… You can track which part eats most memory
Jun
29
awarded  Autobiographer