Viewing 15 posts - 7,111 through 7,125 (of 19,560 total)
SQL Kiwi (1/17/2012)
Perhaps SSC should go dark too. Or just the 'getting worse' questions 🙂
Maybe twitter too?
I think it would be worth the statement.
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
January 17, 2012 at 4:17 am
SQL Kiwi (1/16/2012)
SQLRNNR (1/16/2012)
babak3334000 (1/16/2012)
For every Column Data Type Is "Bit"Example :
select * from syscolumns where xtype = 104 --: bit
...I would seriously...
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
January 17, 2012 at 4:15 am
True if you are just scripting out the updates. I think the OP wants something that will auto-execute those updates.
These kinds of wide sweeping data changes lend themselves to...
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
January 16, 2012 at 11:33 pm
babak3334000 (1/16/2012)
For every Column Data Type Is "Bit"Example :
select * from syscolumns where xtype = 104 --: bit
Understood.
While you are changing the values,...
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
January 16, 2012 at 11:29 pm
Kingston Dhasian (1/16/2012)
Try it and get back if...
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
January 16, 2012 at 11:22 pm
I would do those updates manually (imho). You need to document what columns of which tables need to change, produce a script for each change that needs to be...
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
January 16, 2012 at 11:15 pm
Straight up question.
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
January 16, 2012 at 10:27 pm
Jeff Moden (1/16/2012)
I'll reserve my opinion on this but thought I'd give everyone a heads up...http://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
Wow
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
January 16, 2012 at 9:29 pm
With one filegroup, the data in the tables is spread across the files in that filegroup (unless partitioned which it doesn't sound like you are doing).
Thus, the tables are not...
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
January 16, 2012 at 5:23 pm
Steve Jones - SSC Editor (10/8/2011)
Some of this is in DMVs.Here's a set of queries that shows some I/O for database files, a few more as well: http://dl.dropbox.com/u/13748067/SQL%20Server%202008%20Diagnostic%20Information%20Queries%20%28September%202011%29.sql
No need to...
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
January 16, 2012 at 4:48 pm
Try this article
http://msdn.microsoft.com/en-us/library/ff773063.aspx
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
January 16, 2012 at 3:57 pm
Have you tried wrapping quotes around the 0? I know you said it is an integer, but I have had success with that in the past.
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
January 16, 2012 at 3:55 pm
Welsh Corgi (1/16/2012)
SQLRNNR (1/16/2012)
Just curiousAre the SSIS packages being source controlled?
I hope.:w00t:
Good question but I have a bad answer; I just found them and I have not yet to...
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
January 16, 2012 at 3:51 pm
Welsh Corgi (1/16/2012)
I do not like the File System.
I only use it in BIDS and deploy it to the server.
I need to think of other reasons.
I suspect that they 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
January 16, 2012 at 3:48 pm
Just curious
Are the SSIS packages being source controlled?
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
January 16, 2012 at 3:44 pm
Viewing 15 posts - 7,111 through 7,125 (of 19,560 total)