Viewing 15 posts - 5,341 through 5,355 (of 5,590 total)
WayneS (5/8/2009)
"CREATE TABLE 'Summary' ('Month' NVARCHAR(9),
'Base1' NVARCHAR(20),
'Retained1' NVARCHAR(20),
'Percent1' NVARCHAR(20),
'Base2' NVARCHAR(20),
'Retained2' NVARCHAR(20),
'Percent2' NVARCHAR(20),
'Base3' NVARCHAR(20),
'Retained3' NVARCHAR(20),
'Percent3' NVARCHAR(20)
)"
Well, I've found out that contrary to many articles on the internet, and even some on...
May 10, 2009 at 9:39 pm
Florian Reischl (5/9/2009)
I learned much more about SQL Server in the last few month than in the last three years.
I have to agree. And it all due to people like...
May 9, 2009 at 9:35 am
Okay, time for the next issue.
The goal of the package is to dynamically build Excel spreadsheets, with a variable number of tabs (worksheets). The # of spreadsheets, the #...
May 8, 2009 at 10:08 pm
Grant Fritchey (5/8/2009)
Have your core questions regarding the index scans & key lookups been answered for the moment?
Well, yes and no. I understand the basic, technical answer of why sql...
May 8, 2009 at 10:00 pm
RBarryYoung (5/8/2009)
Wayne, questions:1) How many total rows are in the SCHT_obligations table?
530,000
2) Have you used the time statistics to confirm if the QP estimates per statement are accurate (i.e., is...
May 8, 2009 at 9:57 pm
Grant Fritchey (5/8/2009)
May 8, 2009 at 10:56 am
Grant Fritchey (5/8/2009)
May 8, 2009 at 9:11 am
RBarryYoung (5/7/2009)
Can you attach the .SQLPLAN in a zip?
Okay, here it is. I'm trying to optimize the last query in the plan.
I have added the following indexes already, which gets...
May 8, 2009 at 7:37 am
Florian Reischl (5/6/2009)
CREATE SCHEMA [%]
GO
CREATE TABLE [%].[%] (Id INT IDENTITY PRIMARY KEY, i INT, [-] INT, [AND] INT, [*] INT, [%] VARCHAR(10))
CREATE INDEX [master.sys.objects] ON [%].[%] ([-]) INCLUDE ([*])
INSERT INTO...
May 7, 2009 at 10:41 pm
You know, the people that help out here are all volunteers. Providing the CREATE TABLE scripts for the tables affected, and INSERT statements to put some test data into those...
May 7, 2009 at 10:27 pm
Well, I'm on a new job, and am investigating performance problems. The first thing I'm looking at is everything that is causing deadlocks.
Every time, the root procedure is performing selects...
May 7, 2009 at 10:23 pm
Lowell (5/7/2009)
you could still add a default constraint later...but that's beside the point.
FYI, MS now calls it a default rule, and not a constraint.
Excellent response to the poster.
May 7, 2009 at 5:03 pm
David Burrows (5/7/2009)
And, heh... don't get me started on the practice of using leading commas in code.
Oh! Come on Jeff don't be coy now :w00t:
For the record, when I code...
May 7, 2009 at 4:35 pm
RBarryYoung (5/7/2009)
Can you attach the .SQLPLAN in a zip?
How do I get it out of SSMS into a zip file?
May 7, 2009 at 3:47 pm
This code seems to work with your test data:
select area, ChartValue = left(ChartValue, len(ChartValue)-1)
from (
select distinct area, ChartValue = (
select
convert(varchar(20),SomeValue) + ', '
from #TestTable
...
May 5, 2009 at 10:12 pm
Viewing 15 posts - 5,341 through 5,355 (of 5,590 total)