Tags » Microsoft SQL Server

SQL Server %%physloc%%

http://sqlity.net/en/2451/physloc/

SELECT*,%%physloc%% ASphysloc

  FROMdbo.tst AST

ORDERBYphysloc;

SELECT*,sys.fn_PhysLocFormatter(%%physloc%%) ASPLF

  FROMdbo.tst AST

ORDER BY PLF;

SELECT * … 24 more words

Microsoft SQL Server

Host Based Computing

In the host based environment, almost all processing occurs on the central host. What little local processing does occur (for instance, with an advanced terminal) is restricted to cursor handling from field to field and handling of individual keystrokes. 157 more words

Microsoft SQL Server

Client server computing

Strictly speaking, Client/server is a style of computing where a client process requests services from a server process. Client server computing is a broad area within cooperative processing, a field that looks at interactive computing between systems.

233 more words
Microsoft SQL Server

Rubber Hits the Road

I have been a SQL DBA for 8 Years and have spent last few years doing a handful of T-SQL and Powershell automations. I intend to document the same here and continue documenting my findings in others areas that interest me. 23 more words

Automation

SQL Server 2014 SP1

First off the SQL Server 2014 SP1 installer complains that fdhost.exe is running…

http://www.smooth1.co.uk/installs/dbinstalls.html#3.1.3 – Updated to also mention 2014 SP1!

Microsoft SQL Server

Extending your metadata with Extended Properties

Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on a object? Well as it happens you can. 503 more words

Microsoft SQL Server

Test first; Mileage may vary;

I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a SQL Saturday before I highly recommend it. 261 more words

Microsoft SQL Server