Viewing 15 posts - 6,001 through 6,015 (of 19,560 total)
Well, did you integrate the FILEPROPERTY function like Jack Corbett recommended on the other thread?
http://www.sqlservercentral.com/Forums/Topic1327652-391-1.aspx
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
July 10, 2012 at 3:44 pm
Once again, starting a new thread does not help much at all.
Please redirect replies to the initial thread
http://www.sqlservercentral.com/Forums/Topic1327819-391-1.aspx
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
July 10, 2012 at 3:41 pm
Jeff Moden (7/10/2012)
SQLRNNR (7/10/2012)
Jeff Moden (7/10/2012)
XMLSQLNinja (7/10/2012)
To get the number in MB:value * 8 / 1024
Example:
Selectname,
size*8/1024
from sys.master_files
Just divide by 124.
Should be 128
Wow... talk about phat phingering. Thanks...
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
July 10, 2012 at 3:40 pm
Danzz (7/10/2012)
I dont get any info from ' Select * from sys.master_files '.Help please!
Do you get an error?
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
July 10, 2012 at 3:40 pm
Danzz (7/10/2012)
I need Available Free Space on of .mdf, .ndf, .ldf on whole instance addinf to existing script.
You have been given enough info to find that info now. This...
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
July 10, 2012 at 3:31 pm
Jeff Moden (7/10/2012)
XMLSQLNinja (7/10/2012)
To get the number in MB:value * 8 / 1024
Example:
Selectname,
size*8/1024
from sys.master_files
Just divide by 124.
Should be 128
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
July 10, 2012 at 3:30 pm
Here's a query to show column level collations
Select t.name as TableName, c.name as ColumnName, ty.name as DataType, c.max_length
,'('+ convert(varchar,c.precision) +','+ convert(varchar,c.scale)+')' as Precision_Scale
,d.definition as DefaultConstraint
,c.collation_name
From sys.tables t
Inner Join sys.columns c
on...
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
July 10, 2012 at 3:19 pm
SSIS
bulk copy
redgate data compare
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
July 10, 2012 at 3:17 pm
XMLSQLNinja (7/10/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
July 10, 2012 at 2:52 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
July 10, 2012 at 2:35 pm
I'm with Jack. If most of the reports are going to be 2008 R2 based, use BIDS from 2008 R2 and develop your SSRS reports from 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
July 10, 2012 at 1:46 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
July 10, 2012 at 1:42 pm
You can have 1 connection manager and have a variable to overwrite the server expression for that connection manager. But only 1 at a time.
A better description of what...
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
July 10, 2012 at 1:41 pm
Lynn Pettis (7/10/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
July 10, 2012 at 1:31 pm
responses are being fragmented
Post further responses here
http://www.sqlservercentral.com/Forums/Topic1327652-391-1.aspx
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
July 10, 2012 at 1:30 pm
Viewing 15 posts - 6,001 through 6,015 (of 19,560 total)