Viewing 15 posts - 1,516 through 1,530 (of 3,221 total)
Steve we have read enough of your work here on SSC to know that your abstract effectively describes your presentation. If there are highlights in your actual presentation...
January 20, 2011 at 10:45 am
mwk (1/20/2011)
Thank you all!! I appreciate the replies. I most likely will do the 2008 Express upgrade at this point.Thanks,
mwk
This is a quick fix, however if 2008 Express...
January 20, 2011 at 10:38 am
mwk (1/20/2011)
the database, but just want to make room by deleting the older records.
Is there...
January 20, 2011 at 9:55 am
I use a "throw away" variable (@BitBucket)
BWAA-HAA!!!
Hmmmm
The quotes aside .. Jeff a great article with more sample code than most of us deserve.
Thanks, as I put...
January 20, 2011 at 7:34 am
This should make a lot of those who help others, know that someone appreciates all the work they do
http://www.sqlservercentral.com/Forums/Topic1050398-391-1.aspx
January 19, 2011 at 3:54 pm
guthey.aditya (1/17/2011)
If you query the system table sys.tables, you should have all the info you are looking for.
Careful, this shows when the table structure was modified, i.e., add a column,...
January 17, 2011 at 4:24 pm
Others will most likely be more helpful than myself, the only way I can think of performing what you want to do is to combine the date columns (BEGINDATE and...
January 17, 2011 at 2:39 pm
Joe
Seriously, does anyone study Yourdon, Gane & Sarson, DeMarco, Constantine, Myers, Dijkstra,
Wirth, Manna, Gries, etc. any more?
Isn't your question about Dijkstra, answered by your own words:
They are mostly old...
January 17, 2011 at 2:16 pm
Each module of code should perform one and only one task.
Do you mean that the MERGE statement in SQL 2008 should NOT exist, because of some one who ranks himself/herself...
January 17, 2011 at 12:23 pm
To help people here to help you, please post your table definition, sample data in a readily useable format. To do this please click on the first link in...
January 17, 2011 at 11:15 am
For Objects of type P, RF, V, TR, FN, IF, TF, and R try this:
SELECT * FROM sys.sql_modules
Which gives you all you want to know. You will...
January 17, 2011 at 10:39 am
The answer to your question is the almost standard answer to any T-SQL question, that is "It depends".
Before making your decision I strongly suggest that you spend some...
January 17, 2011 at 7:49 am
You may wish to read this:
http://technet.microsoft.com/en-us/library/ms190969.aspx
To gain some insight into how a database size grows.
To gain a feeling for your particular tables growth perhaps this will give you some insight,
January 16, 2011 at 1:22 pm
I am not sure that I understand your question completely. The service pack is NOT appiled to what on the CD.
1. Instal what is on the CD to...
January 16, 2011 at 12:55 pm
Viewing 15 posts - 1,516 through 1,530 (of 3,221 total)