Viewing 15 posts - 20,341 through 20,355 (of 59,072 total)
ramrajan (6/15/2015)
But the problem is i am not able to round off the dynamic columns in side my PIVOT...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 15, 2015 at 6:13 am
Ed Wagner (6/15/2015)
1. When are the backups taken?
2. Where are the backups stored?
3. Are the backups viable? Can they be used to restore? Have...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 15, 2015 at 6:09 am
Does anyone have any info on whether or not it's possible to mirror a 2005 server to a 2008 server? I was pretty sure that they had to be...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2015 at 9:20 pm
The safest thing to do for the future would be nightly full backups and log file backups every 15 minutes. That way, you'd never lose more than 15 minutes...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2015 at 9:12 pm
cbrammer1219 (6/14/2015)
USE [dsg]
GO
/****** Object: Table [dbo].[DICE_APDH] Script Date: 6/14/2015 3:44:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2015 at 2:57 pm
You might also have a problem with you Primary Key. In most "Adjacency List" hierarchies, the child (your AccountID) should be the single column PK as well as the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2015 at 1:39 pm
a4apple (6/8/2015)
Currently we have a Hierarchial Tree table that saves our account level information as follows.
sample DDL
CREATE TABLE TreeTable
(
AccountID INT,
SponsorID INT,
[Level] INT,
[Tree] VARBINARY(4000),
CONSTRAINT PK_TreeTable PRIMARY KEY (AccountID, SponsorID, Level)
)
sample...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2015 at 1:29 pm
rnolan 96369 (6/12/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2015 at 4:12 pm
cbrammer1219 (6/13/2015)
923037 ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2015 at 4:05 pm
Alan.B (6/12/2015)
It's a bad idea to use RDP to manage a DB server.
If you're going to say something like that, you need to explain why. To...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2015 at 4:00 pm
That's excellent news. Thanks for posting it.
Still, I think I'll be a whole lot more careful in the future. Even if you can recover, it's a pain in...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2015 at 8:09 pm
DiabloZA (6/12/2015)
You are the man 🙂
I really appreciate your help for the second time 🙂
Can you please guide me to an article or a site where I can...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2015 at 5:26 pm
dcwilson2009 (6/12/2015)
I tried converting it for Powershell ...
If the batch file was working, then I have to ask... WHY?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2015 at 5:09 pm
Eric M Russell (6/12/2015)
Jeff Moden (6/12/2015)
charipg (6/12/2015)
user have db_datareader role in in a database.But user is not able to see the storedprocedures.
any suggestion pls.
I have a different suggestion than the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2015 at 5:07 pm
And still.... even after all of that, nothing to handle true CSV with text qualifiers that work for the way that Excel exports CSV or even TSV. What a...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2015 at 5:04 pm
Viewing 15 posts - 20,341 through 20,355 (of 59,072 total)