Viewing 15 posts - 2,101 through 2,115 (of 6,041 total)
Now that we have SQL Server running on Windows Core and Linux, some of you old-school DBAs will have to get acquainted with command line tools. 🙂
November 1, 2016 at 7:54 am
You have to choose to right tool for the job. Counting vehicles as they pass under a bridge on an eight lane interstate highway is very different than counting financial...
November 1, 2016 at 7:44 am
Did they mention anything about SSIS being ported to Azure PaaS ?
October 31, 2016 at 2:29 pm
Gary Varga (10/31/2016)
Eric M Russell (10/31/2016)
Forget about Zombies and Killer Clowns, it's far more likely your database server will be subjected to attacks from IoT enabled refrigerators and toilets.
I could...
October 31, 2016 at 11:03 am
In most shops, trying to argue with application developers on the issue of proper database modeling and SQL coding is a lost cause. You'll just end up earning a reputation...
October 31, 2016 at 9:39 am
OLAP tools like SSAS are excellent for specific types of data access patterns and are an order of magnitude better at solving these problems than relational and no-sql database platforms....
October 31, 2016 at 8:47 am
Forget about Zombies and Killer Clowns, it's far more likely your database server will be subjected to attacks from IoT enabled refrigerators and toilets.
October 31, 2016 at 8:18 am
Eric M Russell (10/4/2016)
Gary Varga (10/4/2016)
October 31, 2016 at 8:04 am
... he tells me well, that his database via Entity Framework by default just creates all strings as nvarchar(max).
You plenty of reasons to be concerned at this point with this...
October 28, 2016 at 9:27 am
Suth (10/28/2016)
indicies ? do you mean indexes ?
It seems to me that the columns [odid] needs to be indexed; otherwise it's going to do a table scan for each batch....
October 28, 2016 at 9:16 am
The buffer cache contains data and index pages. For example, logical reads are from buffer cache while physical reads are from disk.
The procedure cache contains query execution plans.
October 27, 2016 at 11:10 am
All indexes suggested by DTA are useful within the context of sample query that was supplied to DTA. The problem is that often times these index suggestions are for niche...
October 27, 2016 at 11:01 am
S_Kumar_S (10/27/2016)
like only a sysadmin can create a linked server....
October 27, 2016 at 10:44 am
Zomies?! Orcs?! Haven't you guys got better things to do with your time than sit in the server room playing Dungeons & Dragons?
October 27, 2016 at 9:45 am
By default, a user is in the PUBLIC role and cannot do anything. You then should grant them permissions piecemeal. There are probably 1,000 things a member of SYSADMIN can...
October 27, 2016 at 9:25 am
Viewing 15 posts - 2,101 through 2,115 (of 6,041 total)