Viewing 15 posts - 6,661 through 6,675 (of 19,560 total)
If disk space is limited, I will try and defrag indexes in a selective fashion. Pick a handful here or there and then schedule those for specific nights. ...
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
March 22, 2012 at 5:14 pm
Lynn Pettis (3/22/2012)
Has anyone heard from Barry lately?
Not in a loooooong time.
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
March 22, 2012 at 5:09 pm
A switch can possibly work as well.
Example:
=SWITCH(
IsNothing(Fields!Field1.Value),...
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
March 22, 2012 at 4:46 pm
Lynn Pettis (3/22/2012)
For an urgent error sure not getting any response from the OP and it has been almost 2 hours.
Well, maybe they are fixing it currently and will get...
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
March 22, 2012 at 4:45 pm
From reading it, I agree that it appears to be a custom error. It also appears that from the error - the file being loaded had an XML attribute...
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
March 22, 2012 at 4:38 pm
We migrated several SQL servers (2000 and up) via P2V that involved replication and service broker. Doing it cold, when we brought up the Virtual machine we had 0...
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
March 22, 2012 at 4:35 pm
An iif expression in the visibility property should work.
=IIF( param.Value = False, "somepic.jpg", "")
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
March 22, 2012 at 4:33 pm
gary.p.heath (3/22/2012)
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
March 22, 2012 at 4:30 pm
You might want to read this:
http://www.brentozar.com/archive/2008/08/sql-p2v-what-really-killed-the-dinosaurs/
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
March 22, 2012 at 4:26 pm
You are welcome
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
March 22, 2012 at 4:20 pm
rummings (3/22/2012)
Is there a way to regain Available Space from a database other than Shrinking the database... which leads to index fragmentation.
To reclaim that space to the OS, you would...
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
March 22, 2012 at 2:27 pm
Glad it is fixed and glad to see how to fix it.
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
March 22, 2012 at 2:23 pm
CREATE TABLE [dbo].[FragList](
[ObjectName] [nvarchar](255) NULL,
[ObjectId] [int] NULL,
[IndexName] [nvarchar](255) NULL,
[IndexId] [int] NULL,
[Lvl] [int] NULL,
[CountPages] [int] NULL,
[CountRows] [int] NULL,
[MinRecSize] [int] NULL,
[MaxRecSize] [int] NULL,
[AvgRecSize] [int] NULL,
[ForRecCount] [int] NULL,
[Extents] [int] NULL,
[ExtentSwitches] [int] NULL,
[AvgFreeBytes] [int]...
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
March 22, 2012 at 2:20 pm
Will you provide the code you are using to create fraglist?
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
March 22, 2012 at 2:09 pm
Recap:
Browser service is running
No Active Directory
Can connect via IP address but not by name
This is a named instance
All SQL Instances were completely reinstalled
Is the firewall turned on? Is there...
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
March 22, 2012 at 2:00 pm
Viewing 15 posts - 6,661 through 6,675 (of 19,560 total)