Viewing 15 posts - 826 through 840 (of 5,394 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....
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,...
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,...
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...
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...
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...
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...
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...
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...
January 19, 2015 at 2:33 am
I'm pretty sure it's safe. Back up the whole database to be sure.
January 15, 2015 at 10:53 am
Yes, it is possible. I have done this in the past and it works.
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?...
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 🙂
January 15, 2015 at 4:15 am
You have an allocation error in one of your objects. If possible, restore from backup.
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.
January 15, 2015 at 3:09 am
Viewing 15 posts - 826 through 840 (of 5,394 total)