Viewing 15 posts - 166 through 180 (of 411 total)
Larry,
No problem. I'm glad you see that it is not a trivial thing to make the jump from Access/VBA.
Almost all of your questions are not SQL Server 2008...
June 2, 2011 at 2:47 pm
jcrawf02 (6/2/2011)
I'm going to need to figure out how to hook up with you guys with an ancient, Twitter-impaired phone.
Ha! Maybe you'll all have to post on The Thread....
June 2, 2011 at 12:39 pm
PK's are added to the table structure itself. What you are showing is a select statement, where a PK can not be defined.
I think you want to use ALTER...
June 2, 2011 at 11:04 am
Tara-1044200 (6/1/2011)
June 1, 2011 at 6:15 pm
Welcome to the forums.
Uh. Access and VBA is a looooong way from Azure.
Your migration path totally depends on how much you want to rewrite and what technologies you...
June 1, 2011 at 5:59 pm
Jan Van der Eecken (6/1/2011)
Brings me back to the beginning of my days (pun intended). A different language entirely:
10 Print "I'm not a Re-Curser but I am a Re-Cursor."
20...
June 1, 2011 at 5:04 pm
Jeffrey Williams-493691 (6/1/2011)
Jim Murphy (6/1/2011)
Ninja's_RGR'us (6/1/2011)
Find the job that pages you about low freespace to understand how it works.
great advice.
Also I'd put the growth to something more around 1 GB,...
June 1, 2011 at 4:32 pm
Ninja's_RGR'us (6/1/2011)
Find the job that pages you about low freespace to understand how it works.
great advice.
Also I'd put the growth to something more around 1 GB, 100 mb these days...
June 1, 2011 at 9:59 am
The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte
Brings me back to the beginning of my days (pun...
June 1, 2011 at 9:49 am
To add to what Jason said, data files should 'fill more evenly' (proportional fill) if all data files are the exact same size. If they are lopsided in size, SQL...
June 1, 2011 at 9:42 am
Like other databases, tempdb will not shrink down automatically. It will grow as needed and remain at the larger size unless/until manually shrunk. It is not normally recommended to...
June 1, 2011 at 8:22 am
I grow my files to a size where they won't need to auto grow for a year to 1.5 years. Like the other poster said, you do not want your...
May 31, 2011 at 9:48 pm
GilaMonster (5/31/2011)
Damian Widera-396333 (5/31/2011)
What is the *REAL* question here?The one the thread started with 3 years ago, or the current ones being discussed (26000 posts later)?
I think Michael Earl should...
May 31, 2011 at 5:15 pm
Gander at this: http://msdn.microsoft.com/en-us/library/ms188663.aspx. In the MSDB database, there are system tables that you can query to see the exact error and status of your Agent initiated message and...
May 31, 2011 at 11:37 am
Alan,
You are correct that the BAK, MDF and LDF's should all be separated at a minimum to provide better fault tolerance.
There are other complexities that make separating your...
May 31, 2011 at 11:34 am
Viewing 15 posts - 166 through 180 (of 411 total)