Viewing 15 posts - 7,111 through 7,125 (of 19,564 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.
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...
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...
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,...
January 16, 2012 at 11:29 pm
Kingston Dhasian (1/16/2012)
Try it and get back if...
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...
January 16, 2012 at 11:15 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
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...
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...
January 16, 2012 at 4:48 pm
Try this article
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.
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...
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...
January 16, 2012 at 3:48 pm
Just curious
Are the SSIS packages being source controlled?
January 16, 2012 at 3:44 pm
Viewing 15 posts - 7,111 through 7,125 (of 19,564 total)