Viewing 15 posts - 376 through 390 (of 2,462 total)
SQL* (1/27/2013)
How can we prove this?I have tried checking threw DBCC command, but it is showing the space is allocated.
Can anyone prove for me please.
What has to be proved...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 4:02 am
When a parallel operation is created for SQL Query, there are multiple threads for a single query. Each query deals with a different set of the data (or rows). Due...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 3:58 am
purushottam2 (1/28/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 3:42 am
imani_technology (1/25/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 3:37 am
Also verify blocked processes if any
SELECT
spid
,sp.STATUS
,loginame = SUBSTRING(loginame, 1, 12)
,hostname ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 3:35 am
try these queries
-- Find queries that take the most CPU overall
SELECT TOP 50
ObjectName = OBJECT_SCHEMA_NAME(qt.objectid,dbid) +...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 3:34 am
baabhu (1/28/2013)
I never seen this in my environments of SQLserver 2008 R2. What is your version?
its there http://technet.microsoft.com/en-us/library/ms175536(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 3:19 am
SQL* (1/28/2013)
Is the Data Page contains the data from a single table or multiple tables data.
this wil help you http://msdn.microsoft.com/en-us/library/ms190969(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 3:13 am
purushottam2 (1/27/2013)
I have rebuild-ed all the indexes and updated stats of tables but still SQL is consuming 100%....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 12:39 am
niha.736 (1/27/2013)
How can I go with this SP's while creating or modifying.
if exists (select 1 from sysobjects where name = 'getNotificateProduct')
DROP PROCEDURE [dbo].[getNotificateProduct]
GO
Create PROCEDURE [dbo].[getNotificateProduct]
(
)
begin
....
....
end
IS this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 12:32 am
first the records from both tables will be clubbed then UNION will distinct the records.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 12:28 am
we also do data masking with below steps,
1) updating credit card information (randomly generated alpha-numeric words)
2) emails : adding some irrelevant prefix to profiler name plus changing the domains.
3) upodating...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 12:24 am
see http://technet.microsoft.com/en-us/library/ms175536.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 27, 2013 at 10:29 pm
why cant u use SSIS ? it provide great heterogenous environment
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 26, 2013 at 10:04 am
mpradeep23 (1/25/2013)
can we create database with out using model database or change my model database with other database
any reuirement ? or just a curiosity or interview question ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 26, 2013 at 9:16 am
Viewing 15 posts - 376 through 390 (of 2,462 total)