Viewing 15 posts - 19,021 through 19,035 (of 19,560 total)
I typically use a Char(1) as well. It works nicely for the Y/N or 0/1 or allows for the field to have additional codes added. I have seen...
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
November 25, 2009 at 8:22 am
Grant Fritchey (11/25/2009)
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
November 25, 2009 at 8:17 am
Bru hinted at a very important thing here at SSC. We can offer suggestions for your query, but it is very difficult to provide accurate solutions without having the...
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
November 25, 2009 at 8:14 am
GilaMonster (11/25/2009)
As your log file is very huge, and it is required to Truncate the...
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
November 25, 2009 at 8:05 am
Family
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
November 24, 2009 at 11:59 pm
Woot - just cracked the top 100 here at SSC. It only took 1918 points.
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
November 24, 2009 at 11:51 pm
Turkey for me
Turkey for you
Let's eat the turkey
In my big brown shoe
Love to eat the turkey
At the table
I once saw a movie
With Betty Grable
Eat that turkey
All night long
Fifty million Elvis...
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
November 24, 2009 at 11:48 pm
Bob Hovious 24601 (11/24/2009)
In order to avoid redundancy and repetition and redundancy, we have established an informal rule that newcomers first review...
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
November 24, 2009 at 5:49 pm
this article may be of help
http://hmorgenstern.spaces.live.com/blog/cns!28A6BE83102A0EB3!270.entry
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
November 24, 2009 at 5:39 pm
We had this crop up for us a few months back. We removed the machines and then readded the machine to AD and the issue was resolved.
Seeing the forums...
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
November 24, 2009 at 4:16 pm
SSIS 2008 packages cannot be run from an SSIS2005 store.
However, You can create SSIS2008 packages and run them from an SSIS2008 store to process data from SQL2005 and SQL2000 databases.
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
November 24, 2009 at 11:47 am
pbyrum (11/24/2009)
Current version of Backup Exec on the server is 12 rev 1364?
Do you know what version Backup Exec is in the SP3? I can run updates for Symantec...
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
November 24, 2009 at 11:40 am
I would also suggest reading the Articles posted here at SSC. Some articles are geared toward training, while others may be more in-depth. Pick a topic, read an...
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
November 24, 2009 at 11:34 am
Here is a blog a podcast that should get you on your way.
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
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
November 24, 2009 at 11:27 am
GilaMonster (11/24/2009)
jmartinez-847815 (11/24/2009)
Another item to note is when I run the query analyzer with the 2848 data it suggests I delete ALL indexes within these three tables.
I assume...
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
November 24, 2009 at 11:20 am
Viewing 15 posts - 19,021 through 19,035 (of 19,560 total)