Viewing 15 posts - 46 through 60 (of 440 total)
First of all, I am not an academic guy, but rather a practical guy who have started to dig into SQL Server. As for the comments.
I commented on varbinary...
June 26, 2012 at 1:18 pm
T-SQL type Int is storage-equivalent to VarBinary(4).
T-SQL type BigInt is storage-equivalent to VarBinary(8).
This is definitely not so, as varbinary require a VLB (Variable Length Block), whereas int and bigint does...
June 26, 2012 at 1:53 am
As far as I know, there is no fixed limit, so it depends on the amount of memory required to process and return the records.
June 25, 2012 at 11:58 pm
What you want is covered in Chapter 5 of Pro SQL Server 2005 Assemblies. Basically, you'll write a .NET CLR function querying AD.
June 23, 2012 at 5:16 am
Scalability: Solutions used for adapting to higher load.
Availability: Solutions used to reduce downtime.
Scalability: More hardware, Replication, Always On (SQL Server 2012), Service Broker, to some content Database Mirroring.
Availability: Clustering, Database...
June 21, 2012 at 3:59 am
declare @tempTable table (Id int identity , child_work_id Varchar(max),PrimaryBBPProcess varchar(max),
PrimaryBBPlevel2 varchar(max),PrimaryBBPlevel3 varchar(max),
WorkstreamBusinessGroup varchar(max),WorkBusArea varchar(max),
WorkProjectArea varchar(max))
INSERT INTO @tempTable
SELECT child_work_id = [object_id],
PrimaryBBPProcess = MAX(CASE WHEN tagset_name = ' Primary Financial BBP...
June 21, 2012 at 3:54 am
How to: Add a Hyperlink to a URL (Reporting Services)
The URL you're referencing to should be a File URI.
June 21, 2012 at 2:23 am
Regarding performance: I cannot tell. In some cases in performs better, in some other cases exists, in some cases I can use an inner join. Which one performs better depends...
June 21, 2012 at 1:43 am
Check for known values: in
Eg in ('US','Canada')
select
*
from
table
where
a in (1,2,3)
Check for values retrieved from a different query
Eg in (select CountryName from Countries where Continent =...
June 21, 2012 at 12:35 am
Roust_m (6/20/2012)
Perry Whittle (6/20/2012)If a node failes in a four node cluster you loose 25% of capacity, if a node failes in a two node cluster you loose 50% of...
June 21, 2012 at 12:22 am
It may be that you have service broker filling up your transmission queue. What is the result of the following query?
select count(*) from sys.transmission_queue
June 20, 2012 at 12:30 pm
Something like this?
with CTE as (
select
*,
(select
sum(TranAount)
from
table inner
where
inner.UniqueId <= outer.uniqueid
) agg
from
table outer
)
select
*
from
CTE
where
agg = TranBal
In SQL Server 2012...
June 20, 2012 at 12:24 pm
That is one way of doing it yes, but there is really no need to attempt to insert a record, if you can do a simple test to check whether...
June 20, 2012 at 3:57 am
niclas-1082356 (6/20/2012)
If you know that a query can fail than you can/should check if the query will fail before executing rather than just catching exceptions
Yes, but you should not rely...
June 20, 2012 at 2:02 am
My initial response (as always) is How to prove it's a SAN problem[/url] by Brent Ozar.
If it really is the SAN causing the problems, there is a lot of things...
June 20, 2012 at 1:44 am
Viewing 15 posts - 46 through 60 (of 440 total)