Ms Sql Server Technology Discussions

[JUJUBI_JULABI]

[quote name='Kaarthikeya' timestamp='1356540029' post='1303015790']
good.. ya next option ade chepdam anukunna
[/quote]
hehe .. nuvvu dentlo working .. nenu ssrs chesi 2 yrs aythundi so forgot .. brush up avalli anne inka ..

[deals2buy]

[quote name='JUJUBI_JULABI' timestamp='1356540464' post='1303015816']
hehe .. nuvvu dentlo working .. nenu ssrs chesi 2 yrs aythundi so forgot .. brush up avalli anne inka ..
[/quote]
nenu SQL programming

[Darling999]

idigondi SSRS meeda manchigaa nerchukotaaniki eminaa videos untey post cheyyandi please

[JUJUBI_JULABI]

[quote name='Kaarthikeya' timestamp='1356540826' post='1303015840']
nenu SQL programming
[/quote]
hmmm ..

[deals2buy]

[quote name='DARLING...' timestamp='1356540903' post='1303015845']
idigondi SSRS meeda manchigaa nerchukotaaniki eminaa videos untey post cheyyandi please
[/quote]


last 5-10 pages lo SSRS basics meeda posts esaanu chudu

[deals2buy]

[quote name='JUJUBI_JULABI' timestamp='1356540905' post='1303015847']
hmmm ..
[/quote]
nuvvu?

[ghazni]

[quote name='JUJUBI_JULABI' timestamp='1356539998' post='1303015789']
TQ baa ..

vere solution okati chesna .. backgroud color petesna .. so that numbers are not over writing on each other ...
[/quote]


so em option petali ala kavali antey...........

[Darling999]

[quote name='Kaarthikeya' timestamp='1356540969' post='1303015855']


last 5-10 pages lo SSRS basics meeda posts esaanu chudu
[/quote]
ooh nce yar will check

[JUJUBI_JULABI]

[quote name='Kaarthikeya' timestamp='1356540989' post='1303015856']
nuvvu?
[/quote]
nenu sql bi baa, covered all t sql , ssis, ssrs, ssas .. kani present ga working on ssrs and t sql ...

[JUJUBI_JULABI]

[quote name='ghazni' timestamp='1356541840' post='1303015895']


so em option petali ala kavali antey...........
[/quote]
na requirement enti antey i need both row and columns to be freezed .. so daniki nuvvu row groups and column groups rendu lo fixed data true petali .. kani since i used groupings .. a grouping varaku petodhu .. then back ground lo color peteyali evithey set property true petinamo ade ..

[deals2buy]

[quote name='JUJUBI_JULABI' timestamp='1356541930' post='1303015903']
nenu sql bi baa, covered all t sql , ssis, ssrs, ssas .. kani present ga working on ssrs and t sql ...
[/quote]

SSAS lo MDX queries raasava eppudaina? or else just tool use chesava?

[deals2buy]

[b] Creating Database with Different Collation on Server[/b]


“Can we create a database with different collations on the same SQL Server Instance? We thought, the collation of the server is fixed during the installation and all the database on the system have to follow the same default collation.”

And the answer is "Yes"

[CODE]
-- Create Case Sensitive Database
CREATE DATABASE CaseSensitive
COLLATE SQL_Latin1_General_CP1_CS_AS
GO
USE CaseSensitive
GO
SELECT *
FROM sys.types
GO
-- Create Case In-Sensitive Database
CREATE DATABASE CaseInSensitive
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
USE CaseInSensitive
GO
SELECT *
FROM sys.types
GO
[/CODE]

The above command will create two different databases with Case-Sensitive and Case -Insensitive collations. When we retrieved the default datatypes from the database we can see that they have different collation for their data types. It is absolutely possible to database with a different collation on a same SQL Server Instance. It is also possible to create an individual column in a table with different collations from server instance and database as well.
[img]http://www.pinaldave.com/bimg/collation-is-cs.jpg[/img]

[i][b]Collation can be set at SQL Server instance Level, Database Level as well as Table Column Level. [/b][/i]


One more interesting thing learned today

[deals2buy]

[b] Merge, Metadata and the Data Mart ETL[/b]


http://www.sqlservercentral.com/articles/ETL/94034/

[deals2buy]

Database Deployment: The Bits - Database Version Drift

http://www.simple-talk.com/sql/database-administration/database-deployment-the-bits---database-version-drift/

[deals2buy]

[b]
[url="http://www.sqlservercentral.com/blogs/sqlstudies/2012/12/19/red-errors-in-the-results-pane/"]Red errors in the results pane[/url][/b]