Viewing 15 posts - 16,501 through 16,515 (of 19,560 total)
Jason Shadonix (3/13/2010)
Aglet
Phineas & Ferb
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 13, 2010 at 11:22 am
Paul White (3/13/2010)
GoGreen (3/12/2010)
I am trying to import data from file(txt, xls) using multiple Insert statement.Is there any limitation on query size that SQL server can handle at one time?
That...
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 13, 2010 at 10:59 am
Paul White (3/12/2010)
tosscrosby-60625 (3/12/2010)
BananaramaEpilator
NAIR
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 13, 2010 at 10:55 am
Since many DBA's create an "admin" database to house such things as numbers tables, stored procs, and other administrative types of objects - it is perfectly plausible to house a...
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 13, 2010 at 10:55 am
SQL_Quest-825434 (3/12/2010)
I think Jason has a good post of how to do this:
http://www.sqlservercentral.com/articles/Log+growth/69476/
HTH,
\\K
Thanks, I think it is a good solution 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
March 13, 2010 at 10:44 am
Paul White (3/12/2010)
Jeff Moden (3/12/2010)
We're rootin' for ya!* snigger *
D'oh
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 13, 2010 at 10:26 am
Alvin Ramard (3/13/2010)
Grant Fritchey (3/13/2010)
Alvin Ramard (3/12/2010)
Great job on Twitter Grant. Mention DBCC TimeWarp to Paul and then run. 😀
I haven't logged back into Twitter yet. You're saying...
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 13, 2010 at 10:24 am
I would have to weigh in on the side of permissions. If create or replace only handles them in the event of a replace, then what does it really...
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 12, 2010 at 5:20 pm
FabricioLimaDBA (3/10/2010)
select distinct B.name ,
case type when 'P' then 'Stored procedure'
when 'FN' then 'Function'
when 'TF' then 'Function'
when 'TR' then 'Trigger'
when 'V' then 'View'
end
from...
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 12, 2010 at 5:18 pm
That error relates to an out of space situation in your log file or data file. Make sure your files are properly sized.
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 12, 2010 at 5:09 pm
Take this a step further. Set up roles in your databases. Grant the permissions to the roles. Then add a user to the necessary roles.
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 12, 2010 at 4:44 pm
This will depend as Elliott has said. Compliance you are seeking will have an impact on which encryption you use. It is not uncommon to employ both database...
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 12, 2010 at 4:42 pm
Scott,
Take Lutz' advice here. The task is many times simpler to use the update statement he suggested and perform this query in a set-based fashion. Do not use...
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 12, 2010 at 4:35 pm
gilbert delarosa (3/12/2010)
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 12, 2010 at 4:26 pm
http://msdn.microsoft.com/en-us/library/ms190202.aspx
http://www.amazon.com/Pro-Server-2005-High-Availability/dp/159059780X
http://www.amazon.com/Microsoft-Availability-Clustering-Database-Mirroring/dp/0071498133
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 12, 2010 at 3:57 pm
Viewing 15 posts - 16,501 through 16,515 (of 19,560 total)