Viewing 15 posts - 1,711 through 1,725 (of 1,988 total)
WhiteLotus (5/1/2015)
Grant Fritchey (5/1/2015)
WhiteLotus (5/1/2015)
Grant Fritchey (5/1/2015)
May 1, 2015 at 8:07 am
Lynn Pettis (4/30/2015)
ScottPletcher (4/30/2015)
Don't name the constraint, as constraint names have to be unique.ALTER TABLE dbo.test
ADD PRIMARY KEY CLUSTERED
( ReportRunTime, VisitID, SourceID, BaseID, OccurrenceSeqID, [DateTime], SeqID, QueryID, Response );
Since you...
April 30, 2015 at 12:48 pm
Well if this is just an install on your workstation no one else is using you could change the SQL Server agent to use your account and see what happens...
April 30, 2015 at 11:25 am
What format are the values in the anniversary field? It's a string so you'll need too know that to know how to parse it.
April 30, 2015 at 8:13 am
CELKO (4/30/2015)
mm7861 (4/29/2015)
I am using a calendar table. The code is intended for a stored procedure that will populate the calendar table.
Your mindset is still locked in procedural coding and...
April 30, 2015 at 7:39 am
Are they actually doing anything that causes the databases size to fluctuate enough on a regular basis that this is even worth doing?
April 29, 2015 at 12:56 pm
Is this something like what you were looking for?
WITH CTE_TALLY_10(COL_ONE) AS(
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL...
April 29, 2015 at 10:55 am
Well is your fiscal year going to start on 4/6 every year or will that date change every year?
Weeks don't break into years cleanly the way months do....
April 29, 2015 at 8:24 am
Can you try opening them in BIDS not SSMS, then saving them to a dtsx file and working from there?
April 28, 2015 at 12:19 pm
If the result set isn't too large copy paste works fine.
April 28, 2015 at 9:25 am
In step three you mention that the data is pulled from SQL Server then processed on the target system, can you verify that the performance issue is actually SQL Server...
April 27, 2015 at 1:17 pm
What exactly are you doing with the data, writing it to a file? Is there an application pulling it in one row at a time?
April 27, 2015 at 11:36 am
If they're just developing reports it shouldn't matter what the data is, they should be able to tell you whether the report accurately reflects the data in the database regardless...
April 27, 2015 at 10:40 am
Do your developers really need data that current to do dev work against?
April 27, 2015 at 8:55 am
ScottPletcher (4/23/2015)
ZZartin (4/23/2015)
ScottPletcher (4/23/2015)
Lynn Pettis (4/23/2015)
ScottPletcher (4/23/2015)
Lynn Pettis (4/23/2015)
CELKO (4/22/2015)
Why are you changing obvious integer data types to character data types?
Please read any book on basic data modelling and...
April 23, 2015 at 9:56 am
Viewing 15 posts - 1,711 through 1,725 (of 1,988 total)