Gail Shaw

Forum Replies Created

Viewing 15 posts - 25,801 through 25,815 (of 49,552 total)

RE: How to get storedprocedures parameters with types

They should be in sys.columns. Query sys.procedures join sys.columns
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 6:30 am

#1332468
RE: Reason that might cause Database became In Recovery in SQL Server 2008

RakeshRSingh (6/1/2011)
I just wanted to discuss Fast Recovery Concept of SQL Server. As long as the database is showing (in Recovery) in Management Studio it is Roll-Forward going on. And...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 6:01 am

#1332455
RE: Data format in T-SQL 2005

NText for a date? I wasn't aware dates could reach 2 billion unicode characters in length...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 4:55 am

#1332434
RE: Step-by-step approach for troubleshooting performance issues.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 4:52 am

#1332432
RE: query problem

Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1117940-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 4:32 am

#1332424
RE: Are the posted questions getting worse?

Dave Ballantyne (6/1/2011)
Some people really dont want to be helped do they :crazy:
http://www.sqlservercentral.com/Forums/Topic1116629-9-3.aspx#bm1117914
Yeah...
I always wonder about the threads where someone asks for a bunch of information and the OP replies...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 4:27 am

#1332420
RE: SQL query resouce time

Please post execution plan, table definition, index definitions. See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 3:14 am

#1332408
RE: What is difference between Null and Literal Null?

You're misreading the article.What it talks about is a variable that is null or the literal value NULL. There aren't two types of nulls
SET ANSI_NULLS ON affects a comparison only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 2:26 am

#1332401
RE: Can I upload the profiler trace file into reporting services to get a report...

Yes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 2:22 am

#1332399
RE: Loop Thru a Table

Blood from a stone...
The user defined types?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 2:22 am

#1332397
RE: Loop Thru a Table

You're using a significant number of user defined types. Please post the definitions of all of the ones in that table.
Still needs some sample data (as insert statements) please
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 1, 2011 at 12:04 am

#1332376
RE: Loop Thru a Table

Please, please, please, table definitions as a CREATE TABLE script. I can't copy-paste from a jpg. If you want help don't make the people offering their time do unnecessary work.
That...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

May 31, 2011 at 11:55 pm

#1332370
RE: truncate the log file in simple recovery model in sql server 2005

sri01.sqldba (5/31/2011)
I need to truncate the log file for free disk space in sql server 2005 .
That's not truncating, that's shrinking.
Truncate = mark space in the log file as reusable,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

May 31, 2011 at 11:52 pm

#1332368
RE: Including null in report parameter dropdown

Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1117794-1633-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

May 31, 2011 at 11:50 pm

#1332367
RE: Filtering, Sorting, Drilling in SSRS 2005 Reports

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1117854-1063-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

May 31, 2011 at 11:48 pm

#1332366

Viewing 15 posts - 25,801 through 25,815 (of 49,552 total)