Viewing 15 posts - 19,126 through 19,140 (of 19,560 total)
halifaxdal (11/16/2009)
I have an asp.net web application, I need to connect to another department to retrieve data there, it's a SQL database (not sure if it is 2k5 or...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 16, 2009 at 11:46 am
GSquared (11/16/2009)
GilaMonster (11/16/2009)
Looks like someone needs a basic computer theory course.Clustering: http://www.sqlservercentral.com/Forums/Topic819325-146-1.aspx
SAN: http://www.sqlservercentral.com/Forums/Topic819323-146-1.aspx
RAID: http://www.sqlservercentral.com/Forums/Topic819327-146-1.aspx
I would like to apologize for my answers to all three of those... but I won't. 😀
I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 16, 2009 at 11:40 am
or does the singular just correlate to with (without the out since without is plural)?
What does that make of the SANS Institute?
Just pondering...
Seriously though - check with your server admin...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 16, 2009 at 11:39 am
Lynn Pettis (11/16/2009)
CirquedeSQLeil (11/16/2009)
Lynn Pettis (11/16/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 16, 2009 at 11:36 am
teriyaki
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 16, 2009 at 10:08 am
Lynn Pettis (11/16/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 16, 2009 at 9:51 am
Lynn Pettis (11/14/2009)
Want to talk about broken records?
Spot ON. I kind of think of it as an incoherent rambling soap-box.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 14, 2009 at 8:32 pm
I have to agree with Lynn and Flo on this one. As much as it might be nice to code generically so the code will perform on all DBMS's,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 14, 2009 at 8:31 pm
I think it largely depends on your company.
Many places they are one and the same. The DBA designs the databse, supports production, and reviews code.
Some places they distinguish between...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 14, 2009 at 8:10 pm
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD' WITH ('ONLINE = ON') ;
Should be
SET @command = N'ALTER...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 3:33 pm
IF @frag >= 30.0
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';
In the above script you would add
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 2:44 pm
You can also try SQLSpec. We are in the process of evaluating that currently. It can build some nice "webby" reports.
http://elsasoft.org/index.html
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 11:05 am
Tara-1044200 (11/13/2009)
SELECT Name [Database], Physical_Name [Physical file], size*8 [Size_KB] FROM sys.master_files
where Physical_Name like '%mdf' order by name
From the above query i am getting the list of databases but 5...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 10:57 am
Thanks Gail.
With that note, the query would also change (when using sys.objects).
Select OBJECT_NAME(p.object_id) as TableName,SUM(rows) as NumRows,index_id
From sys.partitions p
Inner Join sys.objects o
on p.object_id = o.object_id
Where index_id in (0,1)
And o.type =...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 10:38 am
dragee
Why?
Just because it has stuck with me since watching the food network the other night.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 13, 2009 at 10:32 am
Viewing 15 posts - 19,126 through 19,140 (of 19,560 total)