Reputation
4,638
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
9 23
Newest
 Civic Duty
Impact
~110k people reached

11h
revised Do Sequences Have the Same Replication Range Limits As Identities?
Added link to back the sequence implementation of identity
12h
answered Do Sequences Have the Same Replication Range Limits As Identities?
Jan
25
answered How to run SQL services on NT SERVICE\MSSQLSERVER account if it is running earlier on LocalSystem
Jan
22
awarded  Civic Duty
Jan
18
comment Steps or suggestion to break up a 2,000 line sql query into many smaller pieces
This might help you: spaghettidba.com/2012/03/15/how-to-eat-a-sql-elephant
Jan
18
comment Accessing Registered Servers over Excel
It's not clear what users should see. All the data? Data specific to a country? How is Excel accessing the data? Is Excel unable to query a four-part name?
Jan
18
comment service broker/resource govenor
@RemusRusanu turn your comment into an answer and I'll upvote it.
Jan
16
comment Return the most recent event in a series of same title events
Here's a good place to start: spaghettidba.com/2015/04/24/…
Jan
14
answered Remove parent and child rows if child or parent fits criteria
Jan
14
comment how to arrange the display base on column values(l_mode e.g 4,5) according to the date they clock-in and clock out
It's unclear to me what you mean here. Can you post table scripts, sample data and expected results please? See here for guidelines: spaghettidba.com/2015/04/24/…
Jan
14
answered SQL Server Backups on DataDomain
Jan
14
comment Calculate the fee with conditions
We need more information in order to help you. See posting hints here: spaghettidba.com/2015/04/24/…
Jan
13
answered because of Date format im not able to get few records
Jan
11
answered Check if a user exists in a SQL Server database
Jan
11
answered Moving SQL Server Agent Job Categories and Schedules
Jan
11
comment Multiple column concatenation
If you need help with that, drop me an email and I'll be happy to help.
Jan
11
answered Multiple column concatenation
Dec
4
comment Locked TempDB Log
No problem, I'm fine with anybody using my code, as long as they find it useful.
Dec
3
comment Change port number for SQL 2012 Cluster
Now I remember that I had one of my clustered instances doing this and I think I fixed it with the remove/add checkpoint. However the correct behavior is automatic checkpointing. Look in the cluster logs to see if something interesting turns up.
Dec
3
comment Change port number for SQL 2012 Cluster
Weird. It's working for me. Are you restarting configuration manager after cycling the instance?