Viewing 15 posts - 12,616 through 12,630 (of 26,486 total)
Check out this article http://www.sqlservercentral.com/articles/T-SQL/68467/ AND the discussion that goes with it.
April 20, 2012 at 9:29 am
Grant Fritchey (4/20/2012)
Tried one more. It won't be right either, but an effort was made.
And you notice, not a word about the code pulled from his other thread, which this...
April 20, 2012 at 9:24 am
Grant Fritchey (4/20/2012)
Tried one more. It won't be right either, but an effort was made.
Sean and I have never gotten a straight answer to anything we have tried. We...
April 20, 2012 at 9:17 am
Show us how you ran the stored procs and got different timings and how you ran them as scripts and got the same timings.
Seeing code will help.
April 20, 2012 at 9:13 am
Just to be sure, in Windows Explorer, does the file exist where sys.database_files says it does (F:\Data\ArchiveData_log.ldf)?
April 20, 2012 at 9:09 am
wdodds (4/20/2012)
TableA
TableB
TableA contains 2 columns: EmployeeID and Code (plus a handful of other elements)
TableB contains 2 columns: EmployeeID and Code (plus a handful of different elements that...
April 20, 2012 at 9:02 am
Lynn Pettis (4/20/2012)
Grant Fritchey (4/20/2012)
Lynn Pettis (4/20/2012)
April 20, 2012 at 8:36 am
To really help would probably need to see some of these queries that are running across linked servers. I am unaware of nay changes to how linked servers work...
April 20, 2012 at 8:32 am
Could you post the code for the stored procedure plus some sample data to be passed into the procedure so we can see how it works (parameters that currently work...
April 20, 2012 at 8:29 am
What do you get when you run this:
msdb.dbo.sp_help_category @class = 'Alert'
April 20, 2012 at 8:24 am
Only way I know is to use a Calendar table that is setup to tell you what days are holidaies, and then code the first step in the job to...
April 20, 2012 at 8:13 am
Grant Fritchey (4/20/2012)
Lynn Pettis (4/20/2012)
I wanted...
April 20, 2012 at 8:09 am
riya_dave (4/20/2012)
create table #temp2(account int,MTD float,
ytd float)
its account in temp1 that is same in temp2
if any value is null for mtd or ytd it will fill
Does this help from your...
April 20, 2012 at 7:17 am
capn.hector (4/20/2012)
Lynn Pettis (4/20/2012)
I wanted to...
April 20, 2012 at 7:10 am
Viewing 15 posts - 12,616 through 12,630 (of 26,486 total)