Viewing 15 posts - 301 through 315 (of 8,415 total)
Sergiy (9/6/2012)
But - why would Statistics pages become dirty if no writing is performed against the data page?
See http://technet.microsoft.com/en-us/library/cc966425.aspx (a white paper referenced by BOL)
Statistics updates are triggered when a...
September 6, 2012 at 11:44 pm
Sergiy (9/6/2012)
Used for data-modification operations, such as INSERT, UPDATE, or DELETE. Ensures that multiple updates cannot be made to the same resource at the same time.
I thought you were asking...
September 6, 2012 at 11:40 pm
Sergiy (9/6/2012)
SQL Kiwi (9/6/2012)
Sergiy (9/6/2012)
SQL Kiwi (9/6/2012)
Taking a shared lock would not give the same behaviour as taking an exclusive lock.Can you bring sopme details please?
The two lock types are...
September 6, 2012 at 11:16 pm
Sergiy (9/6/2012)
SQL Kiwi (9/6/2012)
What do you mean by this?
By updating you're losing data. You might think you don't need it anymore, but still - you're losing data previosly recorded...
September 6, 2012 at 11:13 pm
Sergiy (9/6/2012)
SQL Kiwi (9/6/2012)
Taking a shared lock would not give the same behaviour as taking an exclusive lock.Can you bring sopme details please?
The two lock types are different, and so...
September 6, 2012 at 11:06 pm
Sergiy (9/6/2012)
September 6, 2012 at 10:31 pm
Sergiy (9/6/2012)
S locks applied when a query checks for values being actually changed.
Not necessarily. Locking is an implementation detail. SQL Server can decide for itself what locks to...
September 6, 2012 at 10:05 pm
Erland has a Connect request that seems relevant to this discussion:
http://connect.microsoft.com/SQLServer/feedback/details/320998/add-datediff-big
September 6, 2012 at 5:53 pm
Pavel Sinkevich (9/6/2012)
Temporary tables could be a good improvement if we only need resulting tables in same session.
Global temporary tables e.g. ##Fish 🙂
September 6, 2012 at 3:41 am
sqldba4u (9/6/2012)
There is a requirement to reset SQL Server memory without restarting SQL Services.
Why?
September 6, 2012 at 3:39 am
This looks like a thread without a one-line SQLCLR solution yet :w00t:
-- see later post for updated code --
September 6, 2012 at 3:31 am
sqldba4u (9/6/2012)
Can anyone provide me the contents on how to release/reset Total Server memory in SQL Server 2008 without restarting SQL Services?
Can I ask why? If you are looking...
September 6, 2012 at 2:24 am
vk-kirov (9/6/2012)
For each table name: if we already have such a table in the database, drop it ...
... and say goodbye to a concurrent process (if any) 🙂
Not so good,...
September 6, 2012 at 1:34 am
You can use the context connection to get the server name. Create a non-context connection from that information and then use bulk copy.
September 5, 2012 at 10:49 pm
Viewing 15 posts - 301 through 315 (of 8,415 total)