Viewing 15 posts - 256 through 270 (of 1,192 total)
Visual Studio has a schema comparison tool, if you've got BIDS or SSDT installed it should be there in the Data or SQL menu.
Why it doesn't come with/integrate with SSMS...
December 3, 2014 at 5:23 am
Luis Cazares (11/26/2014)
Jeff Moden (11/26/2014)
Jeff Moden (11/26/2014)
SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)😛
BWAAAA-HAAAAA-HAAAA!!!! ...
November 27, 2014 at 12:47 am
Luis Cazares (11/26/2014)
Jeff Moden (11/25/2014)
How about it folks? There a 1.7 million of you out there. Can we get a few more votes on this...
November 27, 2014 at 12:42 am
Ed Wagner (11/26/2014)
jcrawf02 (11/26/2014)
Stuart Davies (11/26/2014)
Eirikur Eiriksson (11/26/2014)
WayneS (11/26/2014)
..what the vote count was..If I remember correctly it was 135 after my vote
😎
Mine made it 143
it's showing 147 right now, and...
November 26, 2014 at 7:33 am
You just need a group, always on the same field?
Right click on the detail row -> Add Group -> Row Group -> Parent Group... and choose the field you're grouping...
November 26, 2014 at 5:00 am
aicha.techn (11/26/2014)
November 26, 2014 at 4:46 am
SQLRNNR (11/25/2014)
Eirikur Eiriksson (11/25/2014)
Gazareth (11/25/2014)
SQLRNNR (11/24/2014)
Eirikur Eiriksson (11/24/2014)
SQLRNNR (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
November 26, 2014 at 3:26 am
You may be hitting the memory limits on your development machine as VS is 32-bit.
I don't use SSDT or RS 2012 so can't confirm it happens there but I used...
November 25, 2014 at 7:04 am
Are you running the report from the Reporting Services web page, or in Visual Studio/BIDS/SSDT?
November 25, 2014 at 5:57 am
SQLRNNR (11/24/2014)
Eirikur Eiriksson (11/24/2014)
SQLRNNR (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
November 25, 2014 at 3:36 am
spaghettidba (11/21/2014)
Gazareth (11/21/2014)
It works on 2008 R2. I didn't know it existed though, thanks Gianluca!
Thanks, I didn't know it worked on 2008 R2. Maybe it arrived with a later...
November 21, 2014 at 8:52 am
Ed Wagner (11/21/2014)
spaghettidba (11/21/2014)
You don't need xp_fixeddrives any more:
SELECT DISTINCT vs.volume_mount_point
, vs.logical_volume_name
, vs.total_bytes
, vs.available_bytes
FROM sys.master_files AS mf
CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.file_id) AS vs
I must admit I was excited when I saw...
November 21, 2014 at 7:36 am
Gary Varga (11/20/2014)
Gazareth (11/20/2014)
Should$result | foreach $result {remove-item $result.fullname -force}
be
$result | foreach {remove-item $result.fullname -force}
or
$result | foreach {remove-item $_.fullname -force}
The latter. The former doesn't use the current object in the...
November 21, 2014 at 2:51 am
Should
$result | foreach $result {remove-item $result.fullname -force}
be
$result | foreach {remove-item $result.fullname -force}
or
$result | foreach {remove-item $_.fullname -force}
November 20, 2014 at 9:57 am
GilaMonster (11/14/2014)
Luis Cazares (11/13/2014)
g.britton (11/13/2014)
SeanNerd (11/13/2014)
I have a table where we cannot use the typical int identity primary key column. The...
November 14, 2014 at 4:58 am
Viewing 15 posts - 256 through 270 (of 1,192 total)