Welsh Corgi

Forum Replies Created

Viewing 15 posts - 3,451 through 3,465 (of 3,738 total)

RE: MS SQL 2008 backup over internet

Backing up to a remote location is going to be extremely slow.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 3:04 pm

#1128812
RE: How do I show items dated 1 day from current date?

Respectfully, have you looked at the DateDiff Function?
http://msdn.microsoft.com/en-us/library/ms189794.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 2:47 pm

#1128802
RE: Microsoft SQLserver 2008 Training Kit Exam (70-432)

Have you tried it or even Googling it?
I believe that you can.
If you disagree e-mail the Author or better yet try it yourself.
I would not get hung against the axle...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 2:40 pm

#1128797
RE: Risk Associated with read-only access to MSDB

I do not know what the requirement is in this situation but if a user wishes to view a SSIS package they will need a user password....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 12:13 pm

#1128694
RE: Query Windows Event Log within SQL Server

I do not know of an extended procedure that does this.
Do you want to perform this action for SQL Server of from a Windows Script?
http://msdn.microsoft.com/en-us/library/cc280386.aspx
http://www.databasejournal.com/features/mssql/article.php/3562406/SQL-Server-2005---SQL-Server-Integration-Services---Part-12---Logging.htm
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 12:06 pm

#1128689
RE: How do i select the top1 column from a table in a select statement which contains multiple columns from multiple columns

Perhaps I'm asking too much but could you provide the DDL, the DM to insert the Data and your Statement so that you may be better assisted?
Thanks,
WC
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 11:53 am

#1128682
RE: Missing HD Unit in SQL SERVER 2008

I'm sorry Gail.
When I posted my reply your response was not active.
I would have not have responded if I had observed your post...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 11:03 am

#1128651
RE: Missing HD Unit in SQL SERVER 2008

Respectfully,
In order to be provided with assistance you should provided more detailed information about your problem.
I'm not going to plagurize anyone else but if you search this site you will...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 10:59 am

#1128645
RE: Risk Associated with read-only access to MSDB

How often do you refresh the development & QA Environments?
I wrote DTS and SSIS Packages to do this on a routine basis.
This has to be be coordinated and your developers...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 10:44 am

#1128632
RE: Preventing data modification depending on other data state

cowabunga,
I know exactly what you are going through...
Regards,
Welsh "Dick" Corgi
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 10:32 am

#1128621
RE: Preventing data modification depending on other data state

I suspect that the reason that the users are accessing your application via Access & Excel is because that they can't get what they need via your VB.NET Application?
To provide...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 10:29 am

#1128619
RE: Preventing data modification depending on other data state

In my humble opinion Triggers seems to be the only viable option.
Since the changes involve more than one table a Check constraint will not work.
Since Users are accessing the Database...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 4, 2010 at 10:04 am

#1128596
RE: Avoid dynamic SQL

....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 2, 2010 at 10:21 pm

#1127532
RE: Local SQLEXPRESS error

I'm sorry but I will defer to the distiquished members of this forum.
Unfortunately I have gone through some tough times and I do not feel that I could give good...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 2, 2010 at 1:25 pm

#1127384
RE: Avoid dynamic SQL

I'm sorry, I did not understand what you meant by the following:
-----------------------------------------------------------------------------------
I would hope that changing your avatar and community pen-name in relation to this
-----------------------------------------------------------------------------------
WHat are you saying that I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

February 27, 2010 at 12:05 pm

#1126129

Viewing 15 posts - 3,451 through 3,465 (of 3,738 total)