Viewing 15 posts - 6,106 through 6,120 (of 6,676 total)
rbarryyoung (8/28/2008)
Vika (8/28/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 28, 2008 at 2:46 pm
What does 'it does not work' mean?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 26, 2008 at 2:02 pm
I just copied the code you posted and ran it and got the expected results. Are you getting any errors?
Can you run the following and verify the results:
SELECT COUNT(*)...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 25, 2008 at 3:49 pm
rbarryyoung (8/24/2008)
Jeffery, Shouldn't that be:SELECT [columns]
FROM table
WHERE column LIKE 'user1 %';
?
Yes - you are right.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 25, 2008 at 3:29 pm
Lookup LIKE in Books Online - you can use the following:
SELECT [columns]
FROM table
WHERE column LIKE 'user1_%';
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 24, 2008 at 10:17 pm
The express edition does not come with SSMS. You can download a free version SSMSE from Microsoft and use that.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 24, 2008 at 5:58 pm
Yes, you can use the 2005 client tools to manage SQL Server 2000. You can even manage a 2000 instance with the 2008 tools, however - there are a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 24, 2008 at 2:36 am
The source I used for this question is: http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
Another resource is: http://msdn.microsoft.com/en-us/library/ms175527.aspx
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 24, 2008 at 1:51 am
Jeff Moden (8/23/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 23, 2008 at 10:36 am
Please review this article: Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/
For your question, lookup the GROUP BY operator in Books Online. Based upon what you have posted, that is the best guess I...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 22, 2008 at 10:42 pm
When you reply to a post - scroll down a little further and you can select your method of notification. Whatever you select will be saved as your default.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 22, 2008 at 10:39 pm
Right at the top is your Control Panel. Select that, scroll down to Topic Subscriptions and you can mark all topics as Unsubscribe.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 22, 2008 at 8:25 pm
You can review the following articles to get an idea of how to get this done:
Cross-Tabs: http://www.sqlservercentral.com/articles/T-SQL/63681/
Tally Table: http://www.sqlservercentral.com/articles/TSQL/62867/
In SQL Server 2005 you can use the row_number() function and OVER...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 22, 2008 at 3:46 pm
Not real sure what you are looking for - why would you want to open a new query without a connection?
Or, are you looking for a way to open a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 22, 2008 at 3:20 pm
How are you determining where each DOS falls? Is it strictly based upon earlier to later? What version of SQL Server are you using?
Please review the article: Best...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 22, 2008 at 3:06 pm
Viewing 15 posts - 6,106 through 6,120 (of 6,676 total)