Viewing 15 posts - 6,031 through 6,045 (of 6,676 total)
You should not shrink your database on a regular scheduled basis. You should always maintain enough free space in the database to allow for index rebuilds and reorgs -...
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
October 17, 2008 at 4:39 pm
Hemalatha (10/17/2008)
I know that this is a very simple query but somewhere struggling
These are the columns
gps_datetime registrationno, speed
10/10/2008 A123 ...
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
October 17, 2008 at 2:52 pm
psangeetha (10/17/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
October 17, 2008 at 2:46 pm
psangeetha (10/17/2008)
create view test (case_seq,description,case_cred,number)
as SELECT b.case_seq,a.description
,a.case_cred
...
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
October 17, 2008 at 2:23 pm
psangeetha (10/17/2008)
To create a view to generate the case_seq from the form_items table like below:
create view caseseq (case_seq)
as
select b.case_seq from form_items a,case_form b where
b.case_name='test' and a.case_cred=b.case_cred order by...
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
October 17, 2008 at 2:03 pm
Are you sure you really need to store that information? If not, you can return that information using row_number() in the query (or create a view) that would generate...
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
October 17, 2008 at 1:41 pm
Seth, you are right - I missed that 'small' little detail 😉
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
October 17, 2008 at 1:40 pm
CREATE PROCEDURE [dbo].[svg_RiskGetCardLocationByIso]
declare @CardNum varchar(100),
declare @DateFrom datetime,
declare @DateTo datetime,
@IsoNum int,
@CardNumDES3 varchar(100) ='0000000000000000',
@username varchar(100)=''
AS
...
Remove the word declare from the list of parameters. It is not valid at that point and...
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
October 17, 2008 at 1:27 pm
MrBaseball34 (10/17/2008)
I get the dreaded: Subquery returned more than 1 value. Can you see something obvious?
Yes, the following code is the problem:
, (SELECT r.ResourceID
...
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
October 17, 2008 at 1:19 pm
If you are using linked servers, make sure you have RPC enabled on the linked server and you can perform the following:
Execute serverb.databaseb.schemab.procedure;
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
October 16, 2008 at 4:49 pm
Please review the following article and provide the relevant data so we can provide a tested and validated solution:
Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/
In the meantime, you could do something along the lines...
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
October 16, 2008 at 4:39 pm
Here you go:
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
October 16, 2008 at 3:37 pm
I run the integrity check nightly using the PHYSICAL_ONLY option, and weekly perform a full integrity check.
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
October 16, 2008 at 3:11 pm
homebrew01 (10/16/2008)
- Create a Global Group,
- Put Windows users in the Global Group,
- Put that Global Group in 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
October 16, 2008 at 1:50 pm
The only thing I can think of is to use row_number(). You can create a view that is used to select from the table that includes the row_number() calculation...
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
October 10, 2008 at 4:45 pm
Viewing 15 posts - 6,031 through 6,045 (of 6,676 total)