Viewing 15 posts - 6,016 through 6,030 (of 19,560 total)
Simple query
DECLARE @ColName Varchar(128)
SET @ColName = 'yourcolumntosearch'
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 t.object_id...
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:03 pm
Lowell (7/10/2012)
one way is to look at sys.columns, which has an is_identity indicator:
select
object_name(object_id) as TableName,
name As ColumnName,
is_identity
from sys.columns
nice script lowell.
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 12:53 pm
Here's a starter for you
Select * from sys.master_files
From there, you can retrieve the information you need and customize the script to your needs.
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 12:50 pm
It sounds like the data file grew to meet the max restriction on growth for that file. Are you out of disk space too?
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 12:41 pm
Check the connection string that you are using within the application (Access).
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 10:25 am
Jeff Moden (7/10/2012)
Shifting gears a bit, I still think it strange that DBAs will allow such things to go on in SSIS...
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 10:18 am
Cliff Jones (7/10/2012)
crookj (7/10/2012)
Daniel Bowlin (7/10/2012)
rhythmk (7/9/2012)
Possinator (7/9/2012)
SQLRNNR (7/9/2012)
Cliff Jones (7/9/2012)
Ray K (7/9/2012)
Revenant (7/9/2012)
rhythmk (7/9/2012)
Brandie Tarvin (7/9/2012)
Daniel Bowlin (7/9/2012)
HeatwaveHeatstroke
Engine
Piston
V6
V8
HEMI
Barracuda
Fearsome
Foursome
Quartette
Beatles!
Monkees
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 10:14 am
rhythmk (7/10/2012)
mayank.gauswami (7/10/2012)
Can anyone help me and show me right way to prepare for these exams.
please post a good link or book to prepare....basically i need the basic...
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 10:13 am
If you can show that there is data to support a decision, it is more likely to be well received than one based on the experience, instinct, or hunches...
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 10:12 am
I enjoyed the story, 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 10:09 am
EZ PZ
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 10:06 am
One of those subselects returns no data so it results in null. You can get around that with another isnull or a query rewrite. If you provided sample...
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 9, 2012 at 4:28 pm
just use the script example I provided.
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 9, 2012 at 3:30 pm
SELECT
(Select SUM (ISNULL(Amount,0)) From blah1.dbo.Paymenthistory
where Billdesc like '%Blah Blah%'
and Receivedate >= '6/30/2012 00:00:00'
and Receivedate < '6/30/2012 23:59:59')
+
(Select SUM ((ISNULL(Amount,0)) From blah2.dbo.Paymenthistory
where Billdesc like '%Blah Blah%'
and Receivedate >= '6/30/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 9, 2012 at 3:10 pm
Are you able to connect through SSMS from your workstation and from the server itself?
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 9, 2012 at 3:09 pm
Viewing 15 posts - 6,016 through 6,030 (of 19,560 total)