Viewing 15 posts - 35,926 through 35,940 (of 39,771 total)
Reindexing can eat up some space (temporarily) and easily cause the db to grow.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 15, 2003 at 9:56 am
Yikes!! Review every one!!
We get like 400 posts a day here. That's a bit much, but you do bring up an interesting point. "Guru" might be not be the best...
September 15, 2003 at 9:44 am
Thanks for the complement. Tell your friends!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 11:29 am
Antares, you need a beer. Be happy to buy you one when we get together some day.
Interesting peeves. I too have no love for the RIAA and SCO, but also...
September 13, 2003 at 11:15 am
Thanks as well. We've worked hard to build a community. Glad you have found it helpful and looking forward to seeing you help some other people.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL...
September 13, 2003 at 11:08 am
Congrats as well. And thanks for the contributions.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 11:03 am
Congrats, personally answering questions is a nice break from work, much better than cigarettes
.
Plus I learn a few things from watching randome threads.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
September 13, 2003 at 11:02 am
I think Andy Warren has some hard copies. Send him an email and he might be able to get you one (awarren@sqlservercentral.com)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
September 13, 2003 at 10:59 am
research, ask specific questions, learn from others.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 10:50 am
charindex is my vote. IN doesn't work with string variables.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 10:49 am
Tools | Customize
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 10:48 am
Good idea, please post it.
I'd prbably attack it by getting the ASCII code and incrementing that, rolling over on Z, but that's me.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
September 13, 2003 at 10:47 am
OR
If exists( select * from table where val is null)
select 'null'
else
select sum()....
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 10:45 am
Not in Enterprise Manager. You can for the login and if they use QA and the Object Browser, they should get better performance.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
September 13, 2003 at 10:44 am
Good suggestions above. If it's been working and suddenly doen't, either you have a data problem (most likely) or someone changed the code/schema.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
September 13, 2003 at 10:43 am
Viewing 15 posts - 35,926 through 35,940 (of 39,771 total)