Viewing 15 posts - 6,166 through 6,180 (of 6,676 total)
One of the things I haven't seen mentioned here is how to use schema's in addition to roles for granting privileges.
I know that in most systems being converted from 2000...
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 12, 2008 at 10:17 pm
You can use a full outer join.
Declare @TableA Table (Material char(7), Plant int);
Declare @TableB Table (Material char(7), Plant int);
Insert Into @TableA Values('8843NEW', 1001); ...
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 12, 2008 at 9:37 pm
No, you do not need to put the databases into single user mode to rebuild indexes. If you can rebuild the indexes online, this leaves the table accessible while...
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 12, 2008 at 8:49 pm
By any chance, are you trying to upgrade a clustered instance of SQL Server? You will see the white icon next to a clustered instance instead of the normal...
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 12, 2008 at 8:44 pm
California (8/12/2008)
So what happens when i execute the following code:
ALTER INDEX ALL ON Product REBUILD??? I dont see online rebuild option is specified here with the command....
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 12, 2008 at 2:37 pm
You can take a look at RedGates SQL Dependency Tracker tool.
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 12, 2008 at 1:44 pm
antonio.varricchio (8/11/2008)
We have SQL 2005 64Bit Std edition installed in a cluster in pre-production environment. The disks (2, drive M and N) are on a SAN. When...
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 11, 2008 at 8:30 pm
Is there a process that changes the recovery model, say from full recovery to simple and back again?
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 11, 2008 at 8:12 pm
California (8/11/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 11, 2008 at 8:08 pm
GSquared (8/11/2008)
The difference is probably where your Numbers table starts. Mine starts...
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 11, 2008 at 8:01 pm
Did that solve the problem?
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 11, 2008 at 2:40 pm
GSquared (8/11/2008)
declare @SDate datetime, @EDate datetime
select @SDate = '1/8/2008', @EDate = '3/8/2008'
select
dateadd(month, number, -- Months in range
dateadd(day, -1 * datepart(day, @SDate), -- Last Day of (prior) month
dateadd(month, 1, --...
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 11, 2008 at 2:39 pm
Using a numbers table, you can do the following:
Declare @fromDate datetime
,@toDate datetime;
Set @fromDate = '20080115'; -- From date some date in...
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 11, 2008 at 2:32 pm
nwinningham (8/11/2008)
Thomas Hainey 999999 NULL ...
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 11, 2008 at 2:13 pm
I am happy that you are now able to move forward. Glad we could help.
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 11, 2008 at 10:54 am
Viewing 15 posts - 6,166 through 6,180 (of 6,676 total)