Forum Replies Created
Viewing 15 posts - 19,111 through 19,125 (of 19,560 total)
-
RE: Are the posted questions getting worse?
Alvin Ramard (11/17/2009)
Steve Jones - Editor (11/17/2009)
That's funny. I wonder how many people will go there right away and not get it?Probably as many as the one that wouldn't do...
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 -
RE: Importing .dbf and .fpt into sql server 05
Have you tried opening it up in FoxPro?
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 -
RE: Today's Random Word!
sleep
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 -
RE: Performance Monitoring Tools
Confio is pretty nice. I was a part of their focus group.
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 -
RE: Are the posted questions getting worse?
GSquared (11/16/2009)
CirquedeSQLeil (11/16/2009)
Can Anybody help me explain group access and conn strings?No. I'm pretty sure only a limited subset of people can help with that.
😀
Good I could use 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 -
RE: Are the posted questions getting worse?
Can Anybody help me explain group access and conn strings?
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 -
RE: Authentication, web.config, database on another server
YOU don't specify any group at all for your connection string. The group is transparent to your connection string.
You just need to know that your NtAuth user is 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 -
RE: Are the posted questions getting worse?
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 -
RE: Authentication, web.config, database on another server
halifaxdal (11/16/2009)
From your side, you would specify integrated security connection strings from within your app.
connectionString="Data Source=XX.XX.XX.;Initial Catalog=SomeDatabase;Integrated Security=True"
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 -
RE: license for mirroring
1. Yes you could do that. This could be a very solid solution, so long as it is a stable environment. If you should need to 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 -
RE: SSIS - how to watch the values in SSIS variables in debug mode
If the variables are not in the window at the bottom, you will need to open that. During package execution, select the Debug menu, select Windows, and then click...
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 -
RE: Not recognising the sort on a Merge Join.
This is a common occurrence in SSIS. Even if the isSorted property is set and the SortOrder defined in your source, merge joins sometimes ignore them. For 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 -
RE: Top 2 records
Bru Medishetty (11/16/2009)
Use ThisSELECT TOP 2 AppName, Date, Query FROM YOUR_TABLEGROUP BY AppName, Date, Query
I think this is more like what you are seeking
With toptwo as (SELECT AppName, Date, Query,row_number()...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 -
RE: running database clusters
GSquared (11/16/2009)
Jeffrey Williams-493691 (11/16/2009)
GSquared (11/16/2009)
If it has multiple peanuts, it's clustered. If it's just one peanut per database, then it's not. Seems simple to me.What if you have...
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 -
RE: RAID
Agreed with Jeff as far as drive numbers. Get as many drives as you can so long as the controllers can handle it.
As for the preferred RAID level, it...
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
Viewing 15 posts - 19,111 through 19,125 (of 19,560 total)