Viewing 15 posts - 826 through 840 (of 5,393 total)
SQLRNNR (1/21/2015)
Jeff Moden (1/21/2015)
Sioban Krzywicki (1/21/2015)
I hope everyone here is ok with it too...
To be honest, I don't care if someone's eyes are on stems and they leave snail tracks....
-- Gianluca Sartori
January 22, 2015 at 2:09 am
Ville-Pekka Vahteala (1/20/2015)
GilaMonster (1/19/2015)
Officially, according to the government, South Africa uses the , as the decimal point. In reality, everyone, including the government, uses the .
Windows 7,...
-- Gianluca Sartori
January 20, 2015 at 1:13 pm
Ed Wagner (1/19/2015)
GilaMonster (1/19/2015)
Officially, according to the government, South Africa uses the , as the decimal point. In reality, everyone, including the government, uses the .
Windows 7,...
-- Gianluca Sartori
January 19, 2015 at 10:45 am
You already have an answer to this question on this thread. If you're unsatisfied with the answers provided there, feel free to point it out, but please let us know...
-- Gianluca Sartori
January 19, 2015 at 7:10 am
Zohaib Anwar (1/19/2015)
I am not sure how can I check this in SQL Server ?? Is there any option / setting in SQL to enable or disable that??
No, it's a...
-- Gianluca Sartori
January 19, 2015 at 6:29 am
sp_reset_connection is connection pooling that closes connections and puts them back in the pool. This is totally expected and nothing you should worry about.
Analyzing a trace file for you looks...
-- Gianluca Sartori
January 19, 2015 at 5:09 am
Use the Data Collector.
You can create a custom collection set to capture the size of the tables and whatever you need to capture.
You can use Extended T-SQL Collector to...
-- Gianluca Sartori
January 19, 2015 at 4:40 am
I would use the Data Collector for this.
It has built-in collectors for database size and can be extended to monitor what you're looking for. Do you need help to set...
-- Gianluca Sartori
January 19, 2015 at 4:31 am
Koen Verbeeck (1/19/2015)
TomThomson (1/16/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today...
-- Gianluca Sartori
January 19, 2015 at 2:33 am
I'm pretty sure it's safe. Back up the whole database to be sure.
-- Gianluca Sartori
January 15, 2015 at 10:53 am
Yes, it is possible. I have done this in the past and it works.
-- Gianluca Sartori
January 15, 2015 at 10:27 am
It's a known issue.
The TF resolves it, but IMHO a gap or jump in identity column should not be a big deal. Is this really an issue for you?...
-- Gianluca Sartori
January 15, 2015 at 4:40 am
BrainDonor (1/15/2015)
I'm planning to go to PASS too. Good luck with your boss! BTW, does anybody know the dates for PASS 2015?
Thanks. I should have checked before asking 🙂
-- Gianluca Sartori
January 15, 2015 at 4:15 am
You have an allocation error in one of your objects. If possible, restore from backup.
-- Gianluca Sartori
January 15, 2015 at 4:12 am
Looks like corruption. http://www.sqlskills.com/blogs/paul/corruption-errors-msg-5242-level-22/
Run CHECKDB on all your databases and post the results please.
-- Gianluca Sartori
January 15, 2015 at 3:09 am
Viewing 15 posts - 826 through 840 (of 5,393 total)