Reputation
901
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 11
Newest
 Yearling
Impact
~93k people reached

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 Best approach for populating date dimension table
+1. Great answer.
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
Jan
19
awarded  Yearling
Jan
18
comment The memory usage of SQL Server keeps growing
RTM!?! Why? Just Why? RTM is not service pack 1. Which is it???? I doubt you will get any serious help on that old a version. Also I note that you are on a VM. what's the ballon manager settings? Memory reservation? In short, hire a local consultant!
Jan
18
comment The memory usage of SQL Server keeps growing
what version? (R2?) what service pack? What cumulative update?
Jan
18
comment The memory usage of SQL Server keeps growing
The symptom of SQL server using increasing memory is usually a red herring (that's how it is designed, and it will give it back if configured appropriately). More likely when you restart server some bad plans get flushed from plan cache....
Jan
18
comment The memory usage of SQL Server keeps growing
Out of all apps, SQL Server does an amazing job of memory management. Are you sure you have a memory problem, and not poor indexes/bad TSQL? And what Marc_s said... Also, can you explain "25k users " a bit more. Is that 25K+ connections at the same time?