Hubble

ramana3327 (4/29/2015)

---

Hi,

How can we monitor the all tables in all databases and send notifications to the team.

Is there a way to check to find the no of rows and size...

This is what I use, SFTP Task for SSIS

😎

Mirrors

Gun

There are few ways of doing this, which is best depends on the usage. This sample makes the assumption that the table is only queried for a specific insert date...

Quick question, what are the memory configurations for the SQL Server service (min/max memory)?

😎

Quick thought, the order of the columns is irrelevant and cannot be set, neither by a create nor alter statement. The ordinal position is the representation and has nothing to...

Immigrant

Quick thought on optimization, as Alan mentioned, the text() method is faster.

😎

Same XML data sample as before

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @xml XML;

SET @xml =

'<?xml version="1.0" encoding="UTF-8"?>

<result resultID="200">

<status>OK</status>

<message></message>

<countryCode>US</countryCode>

<zoneName>America/Los_Angeles</zoneName>

<abbreviation>PDT</abbreviation>

<gmtOffset>-25200</gmtOffset>

<dst>1</dst>

<timestamp>1430141082</timestamp>

</result>'

Looking at...

For fun, there are few ways of doing this:

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @dt DATETIME = '2014-04-09 13:22:31.544';

;WITH BASE_DATA(TTDATE) AS

(

SELECT DATEADD( HOUR , 14 , CONVERT( DATETIME , FLOOR( CONVERT( NUMERIC(8,1)...

Top

Koen Verbeeck (4/27/2015)

---

Brandie Tarvin (4/24/2015)

---

GilaMonster (4/24/2015)

---

Also watch out for the sun. You can get sun burn far easier at high altitudes than low. Take sun cream, use it liberally, even...

sureshjevani 78421 (4/27/2015)

---

Can some kindly help me how to move sql 7.0 to sql 2008R2. We have 10 databases and there are 15 DTS Packages but when I script out...

SQLRNNR (4/27/2015)

---

Lynn Pettis (4/27/2015)

---

How many people...