Reputation
4,719
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 46 90
Impact
~602k people reached

  • 0 posts edited
  • 6 helpful flags
  • 841 votes cast
Sep
8
comment Option to tell Toad to never split a file which contains multiple objects?
It's the same for Toad 9.7
Jul
21
comment Downsides to using SQL 2012 Upgrade as opposed to a fresh install?
Thanks for the hint to upgrade the databases. At this point in time it is easy to use the upgrade advisor to check them for incompatible items. You better do the same when you attach your databases to a fresh installed server.
Jul
18
comment Should I use SQL JOIN or IN Clause?
Might depend on DBMS. I know for sure that SQL-Server is optimizing Select *. (cf. Itzik Ben-Gan in Microsoft® SQL Server® 2012 T-SQL Fundamentals)
Mar
11
comment What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?
Yes that works for me. SQL-Server 2005, 2008, 2012
Mar
1
comment Is there a setting to force an error when asigning a varchar longer than a variable?
I do not want to change other peoples scripts, I want to to force the system to trow errors when I have to run the script.
Feb
25
comment Is there a concept of an “include file” in SQL Server?
Are you using this feature yourself?
Jan
12
comment Large number of row deletes fails with 'out of log space'
Is TRUNCATE LOG ON CHECKPOINT OPTION on or off?
Jan
4
comment Has somebody got a function that will extend hashbytes to strings of arbitrary length?
Your solution requires a cast like, Select dbo.GetMyLongHash(cast(definition as varbinary(max))) from sys.sql_modules where object_id = object_id('<myproc>'), but that is a little inconvenience for keeping it more general. Yes and your version regards differences in trailing blanks.
Dec
27
comment NULLs in a composite primary key - SQL Server
can you please provide full executable code for option 3.
Dec
27
comment NULLs in a composite primary key - SQL Server
That is exactly my problem how to ensure that for each ID_Pet there is exactly one row in the table determined by type with the same ID
Dec
27
comment NULLs in a composite primary key - SQL Server
I do not understand. I want to keep ID_Cats disjunct from ID_Dogs, so that I can derive the type from the ID alone
Dec
27
comment NULLs in a composite primary key - SQL Server
@gbn I edited my answer. Can you help?
Dec
27
comment NULLs in a composite primary key - SQL Server
Please explain UQ1
Dec
27
comment NULLs in a composite primary key - SQL Server
Technically there are no composed primary keys. All Tables have surrogate primary keys -- NOT NULL IDENTITY PRIMARY KEY
Dec
22
comment Isn't a tab (char(9) ) whitespace in the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3)?
Yes thanks. That helps a lot.
Dec
22
comment Remote RESTORE of database through SSMS
Can you access the sql servers local filesystem by some share?
Dec
21
comment How to write a check constraint to disallow empty varchar fields?
@ypercube CHECK (val > '' ) doesn't work in SQL-Server.
Dec
21
comment How to write a check constraint to disallow empty varchar fields?
+1 But I'm curious if there other ways to write this constraint.
Dec
20
comment How to catch and handle only specific Oracle exceptions?
That is exactly what I condensed from Sathyas proposals myself.
Dec
20
comment How to catch and handle only specific Oracle exceptions?
can't I go just go without the when others raise lines ?