|
|
|
|
|
|
-
Himani Liked 3 Months ago through Blogs | 1 Point
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
-
Himani learned 3 Months ago through Blogs | 1 Point
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
-
Himani Liked 3 Months ago through Blogs | 1 Point
My blog on BeyondRelational.com (BR) is completing two years today! Here's a quick snapshot of the splendid & exciting journey that these two years have been....
|
-
Himani Liked 3 Months ago through Blogs | 1 Point
How can one implement a scenario wherein a table needs to be passed over to a stored procedure, modify the table inside it and then consume the results outside of the procedure? We can share temporary tables through stored procedures and today we look a...
|
|
|
-
Himani Liked 10 Months ago through Blogs | 1 Point
As you know well, VALUES clause is used to insert values to the table
A simple example is
declare @t table (id int , col1 int, col2 int, col3 int)
insert into @t values(1, 14, 12, 24)
select * from @t
But in version 2008, you can do more things...
|
-
Himani learned 10 Months ago through Blogs | 1 Point
As you know well, VALUES clause is used to insert values to the table
A simple example is
declare @t table (id int , col1 int, col2 int, col3 int)
insert into @t values(1, 14, 12, 24)
select * from @t
But in version 2008, you can do more things...
|
-
Himani Liked 10 Months ago through Blogs | 1 Point
May be you already read my earlier post for the COLUMNSTORE index introduced by SQL Server Denali CTP3. I have also posted NEW THINGS which i have learned and what is new.
Now i am going to demonstrate something new about analytical functions commi...
|