Viewing 15 posts - 23,041 through 23,055 (of 39,823 total)
DO NOT shrink the log after rebuilding. It's a waste of resources. The next reindex will grow it again.
The log should be sized for the peak load between log...
July 20, 2009 at 9:11 am
The thing I'd suggest is that you write two stored procedures, which is essentially two methods. Then if you want to build an abstraction, write a 3rd that takes both...
July 20, 2009 at 8:59 am
I'm not sure if the JET (Exchange/blue) engine is better than SQL. Or if it tackles a different problem, but from my basic understanding of Exchange, I'm not sure why...
July 20, 2009 at 8:57 am
The licensing isn't a big deal to me. You allow SQL Server as a part of any Exchange license, but only for Exchange databases. If you put something else on...
July 20, 2009 at 8:54 am
The thing is that SQL doesn't process row by row. It works on the entire table or result set at a time.
So what you can do is write conditions to...
July 20, 2009 at 8:53 am
I think you'd be better off doing the replacement in .NET, but you could use the replacements above.
July 20, 2009 at 8:50 am
The reason is that you're subtracting years, and as Michael's logic shows, you need to account for where in the current year you are in relation to the date of...
July 20, 2009 at 8:49 am
I believe you can use a comma to specify the server.
So for the sales server here: sales.sqlservercentral.com, 1899
would connect on port 1899.
July 20, 2009 at 8:48 am
What doesn't work? By that I mean what behavior is occurring. The trigger looks fine syntactically, but it won't work if multiple rows are updated.
Instead what you'd do is join...
July 20, 2009 at 8:47 am
You need to set up logging in the maintance plan, then check the text files that are created. They will have more details about what is wrong.
July 20, 2009 at 8:43 am
Thanks for the update.
I won't lock the topic, as someone might see something you could do better, but it's good to know what fixed it for you.
July 20, 2009 at 8:42 am
The server may slow down with SHRINKFILE, so be aware of that. You might be better off resizing the files, or if they were small and grew, just restarting the...
July 20, 2009 at 8:41 am
I would encourage you to give a hint and ask them to try to answer the question, even the PhD candidate.
I usually post" We are happy to help, but we...
July 20, 2009 at 8:38 am
Blogs could be a detractor, but they also show you learning, or trying to learn. The fact that you've repeated a "myth" doesn't necessarily mean you're a bad employee. It...
July 19, 2009 at 8:19 pm
Viewing 15 posts - 23,041 through 23,055 (of 39,823 total)