Reputation
931
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 12
Impact
~122k people reached

Mar
18
revised my azure sql database is not connecting with SSMS 2014
added friendly text for link
Mar
18
suggested approved edit on my azure sql database is not connecting with SSMS 2014
Feb
15
awarded  Popular Question
Oct
22
comment What's a good tool for visualizing SQL Agent jobs?
How is this off topic on the DBA site?
Oct
7
comment why I can't delete old transaction log backup files with an existing scheduled job?
"...., differential every hour, and transaction log backups every 30 minutes" - that doesn't seem quite right.
Sep
24
comment SQL Server 2008 r2 sp1 upgrade?
sounds like you need to hire an expert.
Mar
15
comment Handling time zones in data mart/warehouse
This does not answer the question.
Mar
15
comment Handling time zones in data mart/warehouse
@Jon of All Trades: separate Date and Time Dimesions is a common best practice. It reduces the overall dimension cardinality, and in practice we often slice by both date and time, or filter by date and then slice by time.
Jan
19
awarded  Yearling
Dec
28
comment Shrink logs in between user transaction in SQL Server
"I am having a database where there are like billions of records" - in a database that big, I'm surprised the TLog isn't already pre-sized appropriately. - Deleting in reasonable sized batches AND having regular TLogs backups, should not be a problem. I'd also note that in tables as big as you state, partitioning would be the usual technique.
Nov
18
comment Protect SQL Server Express data file
Unless you....Stand over it with a big stick!
Nov
18
comment Protect SQL Server Express data file
Stand over it with a big stick?
Oct
7
comment Handling time zones in data mart/warehouse
I'm not composing an answer as @iValueValue has already done a fine job. Presumably you read his answer?
Oct
7
comment Handling time zones in data mart/warehouse
@billinkc: "I can think of no reason I would want to store date independent of time." - I can. Whenever you are building a cube off the warehouse. Having separate Date and TimeofDay Dimensions is commonplace and best practice.
Sep
19
comment How to force SQL Serve *not* to maintain a log file
" The log file went straight to 10mb+, " - Huh? That's tiny. I have log files as big as 100GB (presized of course)
Sep
19
comment How to force SQL Serve *not* to maintain a log file
" Is there a way to prevent SQL from using it?" - No.
May
28
revised SQL performance issues with remote query across linked server
added 2 characters in body
May
7
comment Restore a backup from SQL Server 2008 R2 to SQL Server 2014
should be possible. you probably have a corrupt or partial file.
Feb
19
comment Trigger to restrict users from creating a new table in the database
Use permissions to "restrict any user from creating a new table in the database "
Feb
5
answered SQL Server 2008 R2 Resource Managment