1,263 reputation
412
bio website spaghettidba.com
location Italy
age 37
visits member for 3 years, 4 months
seen 5 hours ago

Long time DB developer and SQL Server enthusiast.

Blog

Twitter

G+

linkedin

sqlconsulting.it


Dec
18
comment Remove dupes from joins
Any chance you can set up a sqlfiddle for some sample data?
Dec
18
comment Is it advisable to use a temp table when the stored procedure could be run simultaneously by different users?
+1 for the sp_executesql OUTPUT parameter. Many are not aware this is even possible.
Dec
12
answered Is someone trying to hack into my SQL Server Database?
Dec
11
revised hide system databases sql server management studio
added 99 characters in body
Dec
11
comment hide system databases sql server management studio
This is a client-side option that has to set on all the clients and can also be easily reverted to the original behavior.
Dec
11
answered hide system databases sql server management studio
Dec
10
answered Copy every entry from TableA to TableB where the ID is in a textfile containing a list of IDs
Dec
9
answered SQL Server configuring both UCP and MDW on a single server
Dec
5
comment The underlying provider failed on Open. Error in Windows Service
No useful information in the ring buffer? I find it hard to believe. You should be able to tell what is happening. Wild guess: is autoclose enabled in that database?
Dec
5
comment The underlying provider failed on Open. Error in Windows Service
I would start looking into the connectivity ring buffer. See here for guidance: johnsansom.com/… Post relevant informantion found in the ring buffer.
Dec
5
comment Is there any way to access the variables in a dynamic sql which is declared outside the dynamic sql
What exactly are you trying to avoid? Passing Name and Age to sp_executesql?
Dec
4
answered Is there any way to access the variables in a dynamic sql which is declared outside the dynamic sql
Dec
4
comment How to import DB with .sql extension into SQL Server 2012?
"exported from server using PuTTY" makes me think you didn't export from a Windows machine. The .sql extension makes me think it was a MySQL database. I would try to open the .sql file with a text editor: if it contains a lot of INSERT...VALUES it is a MySQL export.
Dec
3
revised SQL Server : how to create user with access only from specific HOSTNAME or IP addres
Improved formatting
Dec
3
revised SQL Server : how to create user with access only from specific HOSTNAME or IP addres
Improved/expanded answer
Dec
3
answered SQL Server : how to create user with access only from specific HOSTNAME or IP addres
Dec
1
answered Replication Madness
Nov
29
comment Import and export Excel data into a SQL server database
Possible duplicate: dba.stackexchange.com/questions/68050/…
Nov
26
comment EXCEPT operator vs NOT IN
I might be overly sensitive, but I think "rubbish answer" falls into the rude category. Moreover, you posted a link to "not exists vs not in", which is not what the OP asked for.
Nov
26
comment EXCEPT operator vs NOT IN
@MarkSinkinson The point is that it's not difficult to find information on the topic. There's no need to be rude.