Viewing 15 posts - 47,116 through 47,130 (of 49,571 total)
Without data I can't test, but your version does look like it should work. I would recommend seperate procs for the cases where the parameters are null, to avoid potential...
March 26, 2008 at 2:16 am
How has the column been encrypted?
March 26, 2008 at 1:20 am
Where does that information you want in the CategoryGroup come from?
Please read the following on how to post problems for the fastest answers.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 26, 2008 at 1:14 am
What recovery mode is your database in? If full, do you have regular log backups running?
March 26, 2008 at 1:07 am
Scott Duncan (3/25/2008)
CREATE INDEX [IX_Application2] ON [dbo].[Application]([DocumentNumber]) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
Ignoring the query for now (will look at it after I've had some coffee)..
I would suggest...
March 26, 2008 at 12:37 am
March 26, 2008 at 12:34 am
Paul Koanui (3/25/2008)
Thanks for the reply. I'm just trying to figure out how two different databases on seperate machines with similar hardware would be performing so differently
Are the...
March 26, 2008 at 12:07 am
DBCC IndexDefrag is deprecated in SQL 2005. Use ALTER INDEX... REORGANIZE instead.
March 26, 2008 at 12:06 am
blahknow (3/25/2008)
Hi Gail, OK I understand there are no arrays.I create a table and i want to split it into "sub lists" (or "sub tables")
Hmmm. Ok. Why do you...
March 25, 2008 at 11:58 pm
Randy Doub (3/25/2008)
March 25, 2008 at 7:16 am
Can't see anything offhand that would make the update fal. It's not as if you're updating a row that the cursor's based off.
I'm not sure a cursor's necessary at all...
March 25, 2008 at 6:04 am
Jeff Moden (3/25/2008)
Proof is always good... gotta love BOL. 😉
Habit from academic writing. Cite it or prove it.
March 25, 2008 at 5:50 am
karthikeyan (3/25/2008)
------------------------------------------Can you tell me why ?
Because it's an alternative to the while loop as you're written it. I'm not saying it will be better or worse in terms of...
March 25, 2008 at 5:48 am
Could you post the code please?
March 25, 2008 at 5:32 am
If you want to run a count(*) on all your tables, that's pretty much the way to do it. You could use a cursor instead of a while loop, or...
March 25, 2008 at 5:27 am
Viewing 15 posts - 47,116 through 47,130 (of 49,571 total)