Gail Shaw

Forum Replies Created

Viewing 15 posts - 9,946 through 9,960 (of 49,571 total)

RE: Log Files Growing, even in Simple Mode

AndrewSQLDBA (2/20/2014)
I would really like the database to not log anything for this data load.
You'd like a failure anywhere in the load to cause the destination DB to be...

February 21, 2014 at 12:10 am

#1690993
RE: Performance Tuning - Proof in the pudding

Shawn Melton (2/20/2014)
Do you bother capturing a before and after to show what you accomplished?
What type of information did you capture (perfmon counters, DMV output, wait stats, etc.)?
Always.
I'll have...

February 20, 2014 at 1:05 pm

#1690868
RE: Are the posted questions getting worse?

PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked into. ETA for...

February 20, 2014 at 12:53 pm

#1690858
RE: Are the posted questions getting worse?

stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
After over 40 000 posts, I don't think it has a topic any longer.

February 20, 2014 at 12:48 pm

#1690852
RE: Are the posted questions getting worse?

SQLRNNR (2/19/2014)
Yay - I'm finally insane!!! :hehe::w00t:
Ooohhhhh...... 😀
*starts typing faster*

February 20, 2014 at 12:44 pm

#1690845
RE: LCK_M_IX on tempdb?

Dird (2/20/2014)
If so hopefully you'll do some that include step-by-step performance issue debugging 🙂
You mean this?
https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

February 20, 2014 at 8:41 am

#1690728
RE: Complex search Functionality with joins

born2achieve (2/20/2014)
Though i hit the cached link still the same message from browser.
I just tried it and the google cache works. Click the triangle next to the search result in...

February 20, 2014 at 5:55 am

#1690639
RE: Complex search Functionality with joins

born2achieve (2/20/2014)
I understand that the site is down. any clue when will be up.
GilaMonster (2/20/2014)
Still fighting with hosting provider and domain registrar. Day 4.
Try http://www.google.com/#q=sqlinthewild+catch+all and view the cached...

February 20, 2014 at 5:48 am

#1690636
RE: Complex search Functionality with joins

born2achieve (2/20/2014)
Hi Gila,
nope.
*sigh* Yes.
The link is correct. The site (as I'm well aware and as I explained above) is down in its entirety.

February 20, 2014 at 5:42 am

#1690629
RE: Complex search Functionality with joins

born2achieve (2/20/2014)
can i have the exact link for the article please. would like to learn.
The link given is correct.

February 20, 2014 at 5:22 am

#1690622
RE: Complex search Functionality with joins

Sean Lange (2/19/2014)
You might also take a look at Gail's article about catch-all queries (although as I write this her blog is down).
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
Still fighting with hosting provider and domain registrar....

February 20, 2014 at 5:21 am

#1690621
RE: create a table with two primary keys.

azhar.iqbal499 (2/20/2014)
Actually, when we define primary key on a table, data is stored in the physical order of primary key
Not true.
The clustered index (not primary key) enforces the logical storage...

February 20, 2014 at 3:12 am

#1690583
RE: IIF Statement

What version of SQL are you working with? If 2005, that's why you're getting an error, IIF was added in SQL 2012.

February 20, 2014 at 2:54 am

#1690577
RE: How is my user getting update permissions through stored procedure?

The relevant page in the docs - http://technet.microsoft.com/en-us/library/ms188676%28v=sql.105%29.aspx

February 20, 2014 at 12:40 am

#1690556
RE: Page Life Expectancy is too low

SQL_Student (2/19/2014)
Thanks a lot for all the assistance, that book that Gila mentioned is quite useful and not only for accidental DBA's :-D....
Thank you.

February 20, 2014 at 12:33 am

#1690555

Viewing 15 posts - 9,946 through 9,960 (of 49,571 total)